Can you make INDEX MATCH MATCH into an array-type formula like SUMIF

[LPrice]

I'm working on a file that will have multiple fabs that I'll need to pull data from. The key vertical lookup will be the building name (in column A), and the key horizontal lookup (column header) will be Electric Units. I need to do an INDEX MATCH MATCH since the columns on each tab won't be in the same order. But since I might potentially have multiple rows with Building X in column A, I need it to do more than just find the first instance of Building X. I need it to sum up all the rows for Building X for the column that has a header of Electric Units. On one tab that column might be column F, on the next one it might be column Z. Has anyone done that before? Getting this done will give me a lot of freedom as I continue to build out this big workbook. Thanks!

 

[Fluff]

Hi & welcome to MrExcel
Maybe something like
=SUMIF(Sheet1!A:A,Test!A2,INDEX(Sheet1!A:N,,MATCH("Electric Units",Sheet1!A$1:N$1,0)))