Looking up a returned value defining a named range
 

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?

Looking up a returned value defining a named range
 

Try:

=VLOOKUP(D15,indirect(AD15),AE1,FALSE)

DRC wrote:

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?

--

Dave Peterson

Looking up a returned value defining a named range
 

Dave
That was exactly the ticket. Thanks for your quick response.
Darcy

"Dave Peterson" wrote:

Try:

=VLOOKUP(D15,indirect(AD15),AE1,FALSE)

DRC wrote:

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?

--

Dave Peterson
.