Prev: Excel 2007 -- Dates in Pivot Tables in wrong order after refresh
Next: ISNA Help Please Please please
From: ck on 8 Mar 2010 10:31
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.
From: Teethless mama on 8 Mar 2010 11:15
=IF(SUMPRODUCT(($C$2:$C$10=A2)*($D$2:$D$10=B2)),"found","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.
 | 
Pages: 1
Prev: Excel 2007 -- Dates in Pivot Tables in wrong order after refresh
Next: ISNA Help Please Please please