Name Range Help

B

Bo

I have a situtation where I want to have a formula display in a cell
the name of a "named range" and use this in a lookup formula.

If in cell A1 I have a formula that returns the name of a range called
DP_1 how can I reference this in the formula.

This does not work:
=vlookup(A6,A1,4,false) (Cell A1 dispalys the named range DP_1)

It works correctly if I use:
=vlookup(A6,DP_1,4,false)

I have 12 named ranges where writing an if statement gets too complex
in a single cell. Hopefully someone will have an idea of how to
reference a cell to mke this simpler.
 
R

Rick Rothstein

Try it this way...

=VLOOKUP(A6,INDIRECT(A1),4,false)

Rick Rothstein (MVP - Excel)




"Bo" wrote in message

I have a situtation where I want to have a formula display in a cell
the name of a "named range" and use this in a lookup formula.

If in cell A1 I have a formula that returns the name of a range called
DP_1 how can I reference this in the formula.

This does not work:
=vlookup(A6,A1,4,false) (Cell A1 dispalys the named range DP_1)

It works correctly if I use:
=vlookup(A6,DP_1,4,false)

I have 12 named ranges where writing an if statement gets too complex
in a single cell. Hopefully someone will have an idea of how to
reference a cell to mke this simpler.
 

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

Similar Threads

Named Range maker code 9
random range of cells via cell names 3
Changing a named range within a formula 1
Would like to create customized named range 2
HELP!!! I can't set formula to cell 1
Vlookup result in a message box 10
Reference Cell in VLOOKUP 5
Selecting a named range, the name of the named range is in a cell 6

Top