Vlookup with a pick list for tables

[Cole]

In Vlookup function for the table array argument, I would like to use a pick
list for the table that will be used. In other words, the customer will
select from a list of named table ranges.
=VLOOKUP(F34,(Select from Drop down list of table ranges),3,FALSE)
It seems when I select from the pick-list cell, with the named table ranges,
it uses this name as a value instead of the array. How can I specify that
this value is a named range?

Thanks

 

[Lars-Åke Aspelin]

In Vlookup function for the table array argument, I would like to use a pick
list for the table that will be used. In other words, the customer will
select from a list of named table ranges.
=VLOOKUP(F34,(Select from Drop down list of table ranges),3,FALSE)
It seems when I select from the pick-list cell, with the named table ranges,
it uses this name as a value instead of the array. How can I specify that
this value is a named range?

Thanks

Use the INDIRECT function.

If H1 is a cell with data validation applied.
The list of valid data can be ranges, .like
A1:C10,D1:E15, and so on

Then put this formula in the cell where you want the result:

=VLOOKUP(F34,INDIRECT(H1),3)

Hope this helps / Lars-ÅKe