If statement with 4 matches

[volsfan210]

Hi -

Have a two sheets with data in columns A,b,c,d and I would like for it to look in column D and return a yes, no if columns a,b,c match

Want it to tell me if column D matches if A,B,C are exact

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,B2,Sheet2!C:C,C2,Sheet2!D:D,D2),"Yes","No")