Looking up a returned value defining a named range

D

DRC

A formula return the word Two. =IF(ISBLANK('Lane Entry'!A17),0,IF('Lane
Entry'!R17=0,'Lane Entry'!S17,'Lane Entry'!R17)).

I then try to use the cell (AD15) which =Two in a vlookup statement. The
text word Two is a named range.
=VLOOKUP(D15,AD15,AE1,FALSE)
D15 = EDMONTONABSASKATOONSK
AD15 = Two
AE1 = (column) 6
The formula returns #N/A
The Vlookup statement should return 44.30.
Is there some way to use a formula output as a named range in another formula?
 
D

Dave Peterson

Try:

=VLOOKUP(D15,indirect(AD15),AE1,FALSE)
A formula return the word Two. =IF(ISBLANK('Lane Entry'!A17),0,IF('Lane
Entry'!R17=0,'Lane Entry'!S17,'Lane Entry'!R17)).

I then try to use the cell (AD15) which =Two in a vlookup statement. The
text word Two is a named range.
=VLOOKUP(D15,AD15,AE1,FALSE)
D15 = EDMONTONABSASKATOONSK
AD15 = Two
AE1 = (column) 6
The formula returns #N/A
The Vlookup statement should return 44.30.
Is there some way to use a formula output as a named range in another formula?
 

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