vlookup table_array

A

A

Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade
 
P

Pete_UK

You would use INDIRECT to do this:

=VLOOKUP(A1,INDIRECT(A2),2,FALSE)

This assumes that keep is in the same workbook, as INDIRECT will only
work with workbooks that are open - if it is in a different workbook
which is open, you will need to include the filename in A2.

Hope this helps.

Pete
 
B

bigshooter

I'm trying to do the same thing except I'm referencing a range in a different
worksheet. It works if the other worksheet is open but I need it to work with
it closed.

Thanks
 
Top