Hi,

Use indirect

=VLOOKUP(2,INDIRECT(C1),2,FALSE)

Where c1 is your table name

Mike

"A" wrote:

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