vlookup table_array
Thanks for the quick response Mike
"Mike H" wrote:
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
|