Name Range Help
 

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.

Name Range Help
 

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.