vlookups using ranges defined from a cell

  • Thread starter Thread starter Harvey
  • Start date Start date
H

Harvey

Hello

I have named up a number of data lists and would like to
access this lists using a reference from a absolute cell
reference For example. Max1 is the named range from
B2:B300 and Max2 is the named range from C2:C300. I would
like to use the lookup a specific range based on the value
in cell A1. i.e. if I input Max1 into cell A1 the Max1
range is accessed etc.

Can anybody help. Just entering Max1 or Max2 into cell A1
doesn't work.

Thanks
 
maybe:

=vlookup(q99,indirect(a1),2,false)

And keep just typing Max1 or Max2 in A1.
 
Back
Top