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!