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!