Home |
Search |
Today's Posts |
#1
|
|||
|
|||
are variable table-array names in functions possible?
Is it possible somehow to use variable table array names in VLookup or
HLookup? I would like to create a drop down list of tables, then use the look-up function against the table designated for example =HLOOKUP(D6,,2) where Scenario is a cell reference to the selection from the drop down list. All I am able to get is an #N/A error. The HLOOKUP function works as expected if I replace the cell reference (ie. Scenario) with an actual table name (eg. Scenario1). JimH |
#2
|
|||
|
|||
Sorry the formula that doesn't work should say =HLOOKUP(D6,Scenario,2) where
Scenario is a cell reference to the selection from the drop down list "JimH" wrote: Is it possible somehow to use variable table array names in VLookup or HLookup? I would like to create a drop down list of tables, then use the look-up function against the table designated for example =HLOOKUP(D6,,2) where Scenario is a cell reference to the selection from the drop down list. All I am able to get is an #N/A error. The HLOOKUP function works as expected if I replace the cell reference (ie. Scenario) with an actual table name (eg. Scenario1). JimH |
#3
|
|||
|
|||
Try
=HLOOKUP(D6,INDIRECT(Scenario),2) "JimH" wrote: Sorry the formula that doesn't work should say =HLOOKUP(D6,Scenario,2) where Scenario is a cell reference to the selection from the drop down list "JimH" wrote: Is it possible somehow to use variable table array names in VLookup or HLookup? I would like to create a drop down list of tables, then use the look-up function against the table designated for example =HLOOKUP(D6,,2) where Scenario is a cell reference to the selection from the drop down list. All I am able to get is an #N/A error. The HLOOKUP function works as expected if I replace the cell reference (ie. Scenario) with an actual table name (eg. Scenario1). JimH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array functions ARGHH! | Excel Worksheet Functions | |||
Array functions ARGHH! | Excel Discussion (Misc queries) | |||
array functions and ISNUMBER() | Excel Worksheet Functions | |||
Array Functions - Two Questions | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |