use a variable array in a formula

J

JPderose

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
 
B

Biff

Hi!

Try this:

A1 = lookup value
B1 = list of range names

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

Biff
 
Top