Vlookup with a pick list for tables
On Thu, 16 Jul 2009 08:48:04 -0700, Cole
wrote:
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
|