Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I reference a dynamic range within a indirect statement?
I used the following to set up a dynamic range named ZIP_VALUE_NAME_LIST:
=OFFSET(BATCH!$AQ$4,0,0,COUNT(BATCH!$AQ:$AQ),1) DEST_ZIP_LIST is another dynamic range: =OFFSET(BATCH!$AB$4,0,0,COUNT(BATCH!$AB:$AB),1) I then want to use the indirect statement within a match formula to return the result. =MATCH(DEST_ZIP_LIST,INDIRECT(ZIP_VALUE_NAME_LIST) ,0) The result is a #REF!. When I use the indirect with the absolute cell range it works. Any suggestions? Thanks, BCW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I reference a dynamic range within a indirect statement?
INDIRECT requires a string that can be interpreted as a range reference.
You're feeding it a range instead. What result are you trying to achieve? In article , BCW wrote: I used the following to set up a dynamic range named ZIP_VALUE_NAME_LIST: =OFFSET(BATCH!$AQ$4,0,0,COUNT(BATCH!$AQ:$AQ),1) DEST_ZIP_LIST is another dynamic range: =OFFSET(BATCH!$AB$4,0,0,COUNT(BATCH!$AB:$AB),1) I then want to use the indirect statement within a match formula to return the result. =MATCH(DEST_ZIP_LIST,INDIRECT(ZIP_VALUE_NAME_LIST) ,0) The result is a #REF!. When I use the indirect with the absolute cell range it works. Any suggestions? Thanks, BCW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT function to reference a named range | Excel Worksheet Functions | |||
INDIRECT with dynamic range | Excel Discussion (Misc queries) | |||
Dynamic cell reference using INDIRECT.. | Excel Worksheet Functions | |||
Sumproduct Indirect Named Dynamic Range using Offset | Excel Worksheet Functions | |||
Indirect and Dynamic Range | Excel Worksheet Functions |