# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to create a formula that fills finds the Sheet (col A) and then the Component (col B) and then adds the value I put in Col H into a cell in the corresponding cell of column of the found sheet.
Solved by M. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 22/08/2018 - 04:23
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 04:23
hi
Excelchat Expert 22/08/2018 - 04:23
Let me download the the file
User 22/08/2018 - 04:24
Thanks
User 22/08/2018 - 04:25
I need to create a formula that finds the Sheet (col A) and then the Component (col B) and then adds the value I put in Col H into a cell in the corresponding cell of column of the found sheet.
Excelchat Expert 22/08/2018 - 04:25
Can you tell the sheet name you are referring to?
User 22/08/2018 - 04:25
For example, it will find the sheet from A1 of the lookup tab
User 22/08/2018 - 04:26
and then find the component on that sheet (B2)
Excelchat Expert 22/08/2018 - 04:27
correct me if I am wrong but you want a formula that when you enter some other reference it brings the value from there. Is that correct?
User 22/08/2018 - 04:27
and then update the price in col I of that found sheet
User 22/08/2018 - 04:27
correct
Excelchat Expert 22/08/2018 - 04:29
The last part is not possible as each product has difference shee
Excelchat Expert 22/08/2018 - 04:30
*sheet
User 22/08/2018 - 04:32
is it possible to make something a set of formulas that i can copy and paste to each sheet?
Excelchat Expert 22/08/2018 - 04:32
Let us first breakdown the big problem in to small pieces.
Excelchat Expert 22/08/2018 - 04:33
What will be the input? I am assuiming NNPN. Is that correct?
User 22/08/2018 - 04:34
hmmm can you rephrase that>
User 22/08/2018 - 04:34
?*
Excelchat Expert 22/08/2018 - 04:35
Sure. As you mentioned that "it will find the sheet from A1 of the lookup table". Can you tell me based on what column are we looking for?
User 22/08/2018 - 04:36
we are looking for the sheet first (A1)
User 22/08/2018 - 04:36
the component second (B2)
User 22/08/2018 - 04:36
B1*
User 22/08/2018 - 04:37
and then the price... column i of that location found
Excelchat Expert 22/08/2018 - 04:38
Sure
Excelchat Expert 22/08/2018 - 04:46
Please take a look at the sheet "Search"
[Uploaded an Excel file]
User 22/08/2018 - 04:47
ok
Excelchat Expert 22/08/2018 - 04:47
So if you enter any NNMP number, it will get all other details
User 22/08/2018 - 04:48
reviewing
Excelchat Expert 22/08/2018 - 04:48
Sure
User 22/08/2018 - 04:50
ah i see what you did... thats really good. but not what i needed. i need to be able to type intothe lookup tab col h and it update a cell of the corresponding sheeyt
Excelchat Expert 22/08/2018 - 04:52
As I mentioned earlier, the update part will not wok as there are different sheets
Excelchat Expert 22/08/2018 - 04:55
I gave the solution for the part where you wanted to get col B and I information
Excelchat Expert 22/08/2018 - 04:57
Are you there?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at