help with matching multiple columns

[Dwise85]

any help would be much appreciated.
i am trying to match multiple columns. not sure how to explain so i will do my best.
if the data in column A matches the data in column Sheet!2A THEN MATCH the same data in column B AND column Sheet!2B and post in column C. if no match then mark as "0"

 

[oldbrewer]

THEN MATCH the same data in column B

do you mean carry out same process with col B and sheet2! col B

so if a pair of matches put a "yes! in column C ??

 

[Dwise85]

all good oldbrewer I just figured it haha =INDEX(Sheet2!A:Z,MATCH(1,(Sheet2!A:A=Sheet1!Y8)*(Sheet2!C:C=Sheet1!AA8),0),2)
thanks anyway