Update my formula to return "Yes" if a match is found, and if not, return the corresponding value

Thanks for your formula. It's return me No like I used to do with my previous formula. But I would like to know the corresponding value in the column C for Sheet2.

I have two Sheets : Sheet 1 and Sheet 2. Both of them have data into columns A, B and C.

So, I am comparing Sheet1!A2, Sheet1!B2, Sheet1!C2 and Sheet2!A2, Sheet2!B2, Sheet2!C2

So if my formula return me No, I would like it to return me the corresponding value into column C from Sheet 2 as the value into columns A & B are the same (maybe A or B) in Sheet 1.