Prev: How can I copy big ranges of cells without drag or copy/paste?
Next: Screen Refreshing Anomaly
From: DRC on 22 Mar 2010 17:40
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?

From: Dave Peterson on 22 Mar 2010 18:15
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
From: DRC on 23 Mar 2010 10:49
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
> .
>
 | 
Pages: 1
Prev: How can I copy big ranges of cells without drag or copy/paste?
Next: Screen Refreshing Anomaly