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

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
random range of cells via cell names 3
Range headings 0
Cumulative formula for word table 0
Would like to create customized named range 2
Insert name and adress from a list in a word document 1

Top