Feb 02 2022 12:44 AM
Hallo all,
Im having some difficuliets with the VLOOKUP function. I would like to type the name of the product and have the price show up next to it.
First of all I made a list and gave each section its own table. For example Tomato has the table: Veggies & Eggs has the table: Diary.
Here I use: =VLOOKUP(Eggs,Diary,FALSE)*Amount
This works fine, but I would like to do it without manually typing the table name into the formula
I also tried to take the table name out of the formula by putting it next to it. This also didnt work, I got the error #N/A.
How can I make this so the formula searches in every table for the right word, instead of having to put the table name in the formula manually each in time?
Thank you
Feb 02 2022 01:25 AM
SolutionFeb 02 2022 01:29 AM
Feb 02 2022 01:37 AM
I'd create just one long list with two columns. You can then use a simple VLOOKUP on the single list.
Feb 02 2022 02:15 AM
Feb 02 2022 01:25 AM
SolutionUse INDIRECT:
=VLOOKUP(C4,INDIRECT(B4),2,FALSE)*D4