| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defining a custom-named Range across several worksheets | Excel Worksheet Functions | |||
| Defining Range Name | Excel Discussion (Misc queries) | |||
| Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
| Defining maximum value from a named range for charting purposes | Charts and Charting in Excel | |||
| Defining a range | Excel Worksheet Functions | |||
Linear Mode
