Forum Discussion
Solved
use VLOOKUP without mentioning table
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 ...
Thank you! This worked.
Do you know if its possible to not mention the tabble array at all? Or make VLOOKUP search in all the table arrays? For example =VLOOKUP(C4,Diary;Veggies;Carbs,2,FALSE)*D4
Do you know if its possible to not mention the tabble array at all? Or make VLOOKUP search in all the table arrays? For example =VLOOKUP(C4,Diary;Veggies;Carbs,2,FALSE)*D4
I'd create just one long list with two columns. You can then use a simple VLOOKUP on the single list.
- I found out how to do it with 3 tabbles. You have to combine the VLOOKUP function with the IFERROR function. So if it can't find the name in the table, it will go to the next one, like this: https://i.imgur.com/oZ0DkNS.png