Variable Table Array Names?

J

JimH

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
 
Top