Multipe match

[CBOYER]

Good afteroon! I am new to Excel and having issues with multiple index/match requests. I have attached an example of what I need and cannot figure out. Colum D, D7:D12, I need the formula to choose either winter or summer depending on B and C choices.

 

[Mike H..]

Good afteroon! I am new to Excel and having issues with multiple index/match requests. I have attached an example of what I need and cannot figure out. Colum D, D7:D12, I need the formula to choose either winter or summer depending on B and C choices.

Hi,

Put this formula in D7, ARRAY enter the formula, see below for how and drag down.

=INDEX($G$6:$P$6,MIN(IF((($G$7:$P$8=C7)*($F$7:$F$8=B7)),COLUMN($G$6:$P$6)-MIN(COLUMN($G$6:$P$6))+1)))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.

 

[Debraj]

Welcome to the forum..

you can try this too..

=INDEX($F$6:$P$6,,MATCH($C7,OFFSET($F$6:$P$6,MATCH($B7,$F$7:$F$8,0),,1),0))

 

[CBOYER]

It worked perfectly, thank you very much Mike!!