Need help creating a formula that searches pairs of cells in a row of multiple cell pairs

Hoping this is possible. I want to have the spreadsheet see which cell has a value and have that value multiplied by a correlating value. There are 5 different pairs of corresponding values, and I cannot figure out how to do it. I believe it will be a Logic Formula with multiple options, saying that if there is a value above 0 in cell A, then multiply by cell B, but if the value is in cell C multiply by cell D, If it is in E multiply by F, G by H, etc.

Please see attached.

Hello and welcome to the forum.

Try this in K2:

=SUMIF(A$1:J$1,"A*",A2:J2)*INDEX(A2:J2,MATCH(SUMIF(A$1:J$1,"A*",A2:J2),A2:J2,0)+1)

Drag the formula down.

Thank you. I will give it a try.

Have a great day.

Emma Shoe

Unfortunately, I did not get that to work.
Thanks for trying.

Emma

I have put the formula from post #2 into the workbook from post #1 and have uploaded the result here.

That is fantastic! Thank you.

Now I have to study it to see how it works so I can understand it.

Thanks again!

Emma

Dave, that is awesome too. Thank you. Might be easier for me to duplicate this one in the future. Seems a little less complicated for me.

Have a great day!!

Emma