Index Match with 3 criteria

[mlh0308]

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))

 

[Fluff]

How about

=IF(AND(ISNUMBER(MATCH($E2,Given!$D$3:$D103,0)),ISNUMBER(MATCH($G2,Given!$F$3:$F$103,0)),ISNUMBER(MATCH($I2,Given!$J$3:$J$103,0))),"yes","no")

 

[mlh0308]

How about

=IF(AND(ISNUMBER(MATCH($E2,Given!$D$3:$D103,0)),ISNUMBER(MATCH($G2,Given!$F$3:$F$103,0)),ISNUMBER(MATCH($I2,Given!$J$3:$J$103,0))),"yes","no")

This worked!! Thank you so so much for the quick response!

 

[Fluff]

You're welcome & thanks for the feedback.