Excel 2007 - Table - Structured References

I have defined a set of data as a table. The data represents various projects with a P&L elements running across columns. In the attachment, see the tab called "Table Source". The table is the lower of the two (titled Projects)

Our analysis effort changes the value in the scenario column to a 1 (we will fund) or 0 (we will not fund). On the "Report" tab, I have built a report as seen in the attachment

I am trying to populate my report by saying 'get the data from the table where the Measure is equal to "X" and the column is Q1 which I thought I could through concatenation. Unfortunately, the structured references used by Tables doesn't permit this as it only allows me to select a column defined in the table. As you can see in the formulas, I have had to hardcode my references for each column and row.

As I am new to excel Tables and structured references I am probably missing something. My ultimate question is: How can you pull data from an Excel table using Structured References when the value of the reference might vary.

Attached: Example