Returning value if conditions are met

[jrbeavers559]

I have two worksheets that I need to find where 3 cells within the row match. The cells that I need to match are CODE, ID, and DATE. I have a master sheet that displays all consumers information and another one that is detailed to a specific demographic. In the master sheet the columns are P, X, and Y, but in the detail sheet, they are C, D, and J.

For example, in my detailed sheet C2 is "40", D2 is 22-apr-17, and J2 is "7896"
In my master sheet that record is on row 68719.

So, I want to return a value "Return" on my master sheet, in column EA if column P matches column C [in detail sheet], column X matches column D [detail sheet], and Y matches J [detail sheet].

Thank you! Sorry for my noob question.

 

[iggy_]

Try this

=IF(SUMPRODUCT(--(Detail!C:C=P68719),--(Detail!D:D=X68719),--(Detail!J:J=Y68719))>0,"Return","")