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!

Perhaps using INDIRECT may help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KerryM1212" wrote in message
...
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!

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!

"Don Guillett" wrote:

Perhaps using INDIRECT may help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KerryM1212" wrote in message
...
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!