Forum Discussion
Solved
INDEX MATCH
Can someone help me with the following formula? =INDEX($C$4:$G$7,MATCH($A11,$A$4:$A$7,0),MATCH($B11,$B$4:$B$7,0),MATCH($C11,INDEX($C$1:$G$1,0),MATCH($E11&$D11,INDEX($C$2:$G$2&$C$3:$G$3,0)))) ...
In F11:
=INDEX($C$4:$G$7,MATCH(1,($A$4:$A$7=A11)*($B$4:$B$7=B11),0),MATCH(1,($C$1:$G$1=C11)*($C$2:$G$2=E11)*($C$3:$G$3=D11),0))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Then fill down.
In F11:
=INDEX($C$4:$G$7,MATCH(1,($A$4:$A$7=A11)*($B$4:$B$7=B11),0),MATCH(1,($C$1:$G$1=C11)*($C$2:$G$2=E11)*($C$3:$G$3=D11),0))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Then fill down.
Han, isn't the "*" trying to multiply?