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.

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



"ck" wrote:

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.