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

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