Forum Discussion
IF MATCH COMBINATION
Hello All, In the attached sample file, Cell P3:R4, I would like to return the corresponding data relative to P1 and R2. What would be a good IF/MATCH? combination to use to return the data alre...
=INDEX($B$3:$J$4,MATCH($O3,$A$3:$A$4,0),MATCH(1,(P$1=$B$2:$J$2)*(P$2=$B$1:$J$1),0))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thanks NikolinoDE. Column P works. But in Q3, for example, the numbers should be 7.86 and Q4 should be 74.08, etc.
Maddy1010 In P3, use this as an alternative:
=INDEX($B$3:$J$4,MATCH($A$3:$A$4,$O3:$O4,0),MATCH(P$2&P$1,$B$1:$J$1&$B$2:$J$2,0))