vlookups using ranges defined from a cell

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
 
D

Dave Peterson

maybe:

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

And keep just typing Max1 or Max2 in A1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top