Need help with formula !

  • Thread starter Thread starter Lesley
  • Start date Start date
L

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 B2:D4 is named Oranges

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

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

Thanks

Lesley
 
Back
Top