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.