Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup using a dropdwn list, check different tables based on drop | Excel Worksheet Functions | |||
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple | Excel Worksheet Functions | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Pick List | Excel Discussion (Misc queries) |