View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cole Cole is offline
external usenet poster
 
Posts: 8
Default Vlookup with a pick list for tables

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