How do I index match with three criteria and return a Yes if all three criteria are met or No if not? This is what I have so far and it is not working out. Thanks for all help given!
=index($E$2:$I$95,match($E2,Given!$D$3:$D103,0),match($G2,Given!$F$3:$F$103,0),match($I2,Given!$J$3:$J$103,0))
=index($E$2:$I$95,match($E2,Given!$D$3:$D103,0),match($G2,Given!$F$3:$F$103,0),match($I2,Given!$J$3:$J$103,0))