Variable Table Array Names?

G

Guest

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).
 
W

Wayne Morgan

The functions you are asking about are Excel functions. You will get better
help in one of the Excel newsgroups. This group is for the Access Database
program.
 
L

Larry Daugherty

Dang! Access, the relational database product from Microsoft still
doesn't know anything about Excel functions.

You might have better luck posting in an Excel newsgroup.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

are variable table-array names in functions possible? 2
Assigning a worksheet name to a variable 3
variable reference in hlookup array 5
Variable Table Array in Lookup Function 6
Array-friendly functions 1
HLOOKUP Formula Error 1
Replacing the row index in HLOOKUP 5
Can you combine VLOOKUP with a nest HLOOKUP? 3

Top