Need help with formula !

[Lesley]

Hello,

I would like to create a lookup formula where instead of
naming the table array within the formula I would name a
cell which contains the name of the table array...

Where:

A1 = Oranges

And:

Cell reference B24 is named Oranges

Is there anyway of entering =vlookup(E2,A1,2) rather than
=vlookup(E2,Oranges,2)or =vlookup(E2,B24,2)??

I'm not sure I have explained myself properly but I would
really appreciate any help.

Thanks

Lesley

 

[Kieran]

Something like =vlookup(E2,INDIRECT(A1),2) should do it.

 

[Lesley]

Thanks for your help Kieran