Product If Formula for Two Columns based on Current Month

[Excellent022]

Hello,
I'm struggling to write the formula that would multiply two cells in two different columns based on one of the columns having a header that matches my reference cell. Below is a basic outline of what I'm trying to do. My reference cell is D1 with a formula that returns the current month. I need a formula for E3 that will search for the May column, then multiply C3 by D3. Any help with this? I tried a Product If formula but got hung up. Thank you!

A B C D E

1 May

2 January February May Cost Total

3 1 3 5 100

4 2 4 6 200

 

[Excellent022]

Apologies, the data formatting got weird.
A B C D E
1 M
2 J F M C T
3 1 2 3 100
4 4 5 6 200

 

[shaowu459]

Upload a screenshot of your data is a better way.

工作簿1
	A	B	C	D	E
1				May
2	January	February	May	Cost Total
3	2	3	5	100	500
4	2	4	6	200	1200
Sheet1

Cell Formulas
Range	Formula
E3:E4	E3	=INDEX(A3:C3,MATCH(D$1,A$2:C$2,))*D3

 

[Excellent022]

Upload a screenshot of your data is a better way.

工作簿1
	A	B	C	D	E
1				May
2	January	February	May	Cost Total
3	2	3	5	100	500
4	2	4	6	200	1200
Sheet1

Cell Formulas
Range	Formula
E3:E4	E3	=INDEX(A3:C3,MATCH(D$1,A$2:C$2,))*D3

Thank you for letting me know. I tried the formula and it brought back #N/A. Here's the snippit of my actual spreadsheet. Did I do something incorrect?

 

[shaowu459]

you miss something, you missed "," for MATCH, the last parameter.
=INDEX(A3:C3,MATCH(D$1,A$2:C$2,))*D3

 

[Excellent022]

you miss something, you missed "," for MATCH, the last parameter.
=INDEX(A3:C3,MATCH(D$1,A$2:C$2,))*D3

Oh jeeze...I did. And it worked! Thank you so much!

 

[shaowu459]

thanks for you feedback and have ha nice weekend?