Formula Help

[ck]

I have 4 columns:

Column A Column B Column C Column D
First Name Last Name First Name Last Name

I want to know if the First and Last Name in Column A & B can be found in
Column C & D. Thanks.

 

[Teethless mama]

=IF(SUMPRODUCT(($C$2:$C$10=A2)*($D$2:$D$10=B2)),"found","not found")