Hi!

Try this:

A1 = lookup value
B1 = list of range names

=VLOOKUP(A1,INDIRECT(B1),2,0)

Biff

"JPderose" wrote in message
...
I'm trying to use Vlookup and in the table_array, i would like it to be a
cell that has a validation list of the names of several range names