G
Guest
Okay. This didn't work for me at all for some reason.
I am rather ignorant when it comes to entering a formula that is more than
basic math computations or cell references within the same worksheet.
What is the "2" for in the formula?
Okay, maybe if I asked the question better, that would help.
Worksheet 1 is called "Suppliers" and Column A has the Supplier Number and
Column B has the Supplier Name.
Worksheet 2 is called "Master IPS Damage Log" and the Supplier Number (some
Supplier Numbers start with a "0" so I had to format the cell as Text so the
zeros would show in the cell and not eliminate them) is entered in numerous
locations throughout the sheet. Each page on the sheet has approximately 9
or 10 "forms" on it, one for each Incident Number. For example, Incident #
042205I400 has a set of cells for related data entry, and the first form has
the Supplier Number entered in cell G8, for which I need the Supplier Name to
be automatically entered into cell B10 based on the columns in the
"Suppliers" worksheet.
The next Incident # 042205I401 would have the Supplier Number entered into
cell G13, for which the Supplier Name would need to automatically be entered
into cell B15, and so on and so forth for the rest of the proceeding Incident
Numbers and pages on the worksheet.
So based on this information, could you tell me the exact text for the
formula I would need to type into cells B10, B15, B20, etc., on the Master
IPS Damage Log" worksheet to get this to work?
Thanks in advance for your help...
-Christopher
I am rather ignorant when it comes to entering a formula that is more than
basic math computations or cell references within the same worksheet.
What is the "2" for in the formula?
Okay, maybe if I asked the question better, that would help.
Worksheet 1 is called "Suppliers" and Column A has the Supplier Number and
Column B has the Supplier Name.
Worksheet 2 is called "Master IPS Damage Log" and the Supplier Number (some
Supplier Numbers start with a "0" so I had to format the cell as Text so the
zeros would show in the cell and not eliminate them) is entered in numerous
locations throughout the sheet. Each page on the sheet has approximately 9
or 10 "forms" on it, one for each Incident Number. For example, Incident #
042205I400 has a set of cells for related data entry, and the first form has
the Supplier Number entered in cell G8, for which I need the Supplier Name to
be automatically entered into cell B10 based on the columns in the
"Suppliers" worksheet.
The next Incident # 042205I401 would have the Supplier Number entered into
cell G13, for which the Supplier Name would need to automatically be entered
into cell B15, and so on and so forth for the rest of the proceeding Incident
Numbers and pages on the worksheet.
So based on this information, could you tell me the exact text for the
formula I would need to type into cells B10, B15, B20, etc., on the Master
IPS Damage Log" worksheet to get this to work?
Thanks in advance for your help...
-Christopher