Excel: How to Use IF Function with INDEX MATCH
https://www.statology.org/excel-if-index-match/
webMay 23, 2023 · =IF(B1 ="Mavs",(INDEX(A7:D9,MATCH("Guard", A7:A9,0),3)),IF(B1 ="Pacers",(INDEX(A13:D15,MATCH("Guard", A13:A15,0),3)))) This particular formula first checks if the value in cell B1 …
DA: 26 PA: 89 MOZ Rank: 50