Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |