How about some details........

Where is the lookup table (cell references)?

Do the selections from the drop down refer to different tables or the same
table but different sections?

How about some examples?

Biff

"B Golden" wrote in message
...
I am attempting to have a variable reference to the table array in the
vlookup function. I have created a pull down list in A1 and want the
results
of the pull down list to then reference the name of a corresponding table
array lookup. It seems that I have to either reference the name itself in
the formula and it is not able to reference the results of pull down menu
A1.

Any help is appreciated!

--
BDG