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?
Click to expand...
 

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

VLOOKUP returning #N/A result 2
Dynamic named range reference from external workbook 2
how do i use the text in a cell as a named range in a vlookup form 2
Vlookup using a reference to a named range?(Excel 2000) 4
totally lost - named range and vlookup 13
A find formul looking at two named ranges for two strings 8
Can I use a named range in SUMPRODUCT? 2
trouble with (complicated) vlookup searching another workbook 2

Top