Forum Discussion
jesseisunavailable
Feb 02, 2022Copper Contributor
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 ...
- Feb 02, 2022
HansVogelaar
Feb 02, 2022MVP
jesseisunavailable
Feb 02, 2022Copper Contributor
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
- HansVogelaarFeb 02, 2022MVP
I'd create just one long list with two columns. You can then use a simple VLOOKUP on the single list.
- jesseisunavailableFeb 02, 2022Copper ContributorI 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