Index/Match function: How to make row lookup array dynamic or variable

I know you can make the colum in an index match function variable by using a 0 for the row index. But in the match function in the column field, when selecting the lookup array for your headers is it possible to make that variable where it searches for a value and then wherever it finds that value it uses that row as the lookup array.


Please see my spreadsheet, it makes it very clear what I am trying to achieve and is well layed out.


more detailed explanation below:

The Index match function below has dynamic column selection in that rather than selecting the column range for criteria or to sum, it finds the proper column from the headers in the table (columns can be in any order) Is it possible to make it so that in the following match function: MATCH(Table!$A$8, 'Raw Data'!$1:$1, 0), the lookup array or "'Raw Data'!$1:$1" portion is variable. Meaning that rather than having to manually choose or lock in the row 1:1 as the header lookup array, instead the formula searches for the word/header "House" in the raw data worksheet, then whatever row it finds the word house in, it designates as the row for the lookup array. This way if the raw Data export was pasted in such that the headers were in row 2 or 4 or 47, it would still find the data and select the proper row for the lookup array and thus the formulas would continue to work properly. The headers are unique and would only appear in the raw data once, and only be used as the header. Is what i am trying to achieve possible


Again for a clearer understanding view the attached spreadsheet and read/follow the two text boxes and it will be exactly clear what I am trying to accomplish

Thank you for any help