I want to use the SUMPRODUCT function instead of multiple IF statements. I have a row of numbers that need to be multiplied by a row of conversion factors. There are multiple rows of conversion factors to choose from based on certain criteria. Is there a function to look up an entire row? I've only been able to find how to index/match one number. I've attached a simple spreadsheet.

I showed what I want to happen if i choose the array manually. =SUMPRODUCT(B3:H3,B9:H9)=448

In Table 1 I want to use the criteria in column A to look up the row in table 2. So essentially =SUMPRODUCT(B4:H4,look for A4 in A8:A12 and use columns B:H in corresponding row)

Does any of that make sense? Is this even possible?

Thanks in advance.

SUMPRODUCT question.xlsx