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.
- can you help me with what a spill error is?
- never saw it used like this, but it works.. thank you so much!!
- i tried it on my personal laptop & it worked. when it did it on my work laptop, i got a "spill" error...can you help me with that
I don't see why it would cause a spill error. Could you attach a sample workbook demonstrating the problem, or make it available through OneDrive, Google Drive or Dropbox?
- Han, isn't the "*" trying to multiply?
