Is there an easy way to connect VLOOKUP from defined Table to another defined Table? Is there a better function to do this? I'm trying to get away from using relative cell/column locations.
When I do a VLOOKUP in a table and reference another table, I get something like the following:
What I'd like to be able to do is identify the following in a function:
Is there a function that does something like that? Or is there a way to make VLOOKUP work that way?
When I do a VLOOKUP in a table and reference another table, I get something like the following:
=VLOOKUP([@[Favorite Fruit]],Fruit[[Fruit]:[Cost]],2,FALSE)
What I'd like to be able to do is identify the following in a function:
- lookup_value: @[Favorite Fruit]
- table_array: Fruit[#all]
- lookup_column: Fruit[Fruit]
- return_column: Fruit[Cost]
Is there a function that does something like that? Or is there a way to make VLOOKUP work that way?
