Indexing for data found within a Table Query

[KerryM1212]

So, my workbook looks something like this:

One tab has an index formula referencing named ranges within a second tab.
Within that second tab is data that, when refreshed (right click, refresh),
pulls in new data outside of Excel.

Without that Table Query, my index formulas work fine. However, when I
introduce said query, my index formulas don't work. Any ideas how I can keep
both the query and the index formula?

Thanks!

 

[Don Guillett]

Perhaps using INDIRECT may help

 

[KerryM1212]

Hi Don,

Thanks for the reply. The index formula is actually using Indirect. It looks
like this:

=INDEX(INDIRECT($Z129),MATCH($V$120,IF(REP_GRP_ID=$W$120,IF(SVC_AREA_ID=$X$120,CLIENT_ID)),0))

Without the query, this formula works great! With it however, it gives me a
#REF!