Indexing for data found within a Table Query

[umass02]

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!

[stanleydgromjr]

umass02,

Please post your workbook - scroll down and see "Manage Attachments".


Have a great day,
Stan