Checking data in 2 columns against a further 2 columns....
 

I need to check the values of two columns agains another two colums (with
same data) and if they are both in the sheet return a positive result, or if
wrong return a "Missing Order".

Example:
A B C D
E
SENT Received CHECK
Account Order Date Account Order Date
123 01/12/2009 314 05/12/2009
231 02/12/2009 142 04/12/2009
314 03/12/2009 123 01/12/2009
142 04/12/2009


So I need to take the info from Colum A and B (account and order date) and
see if the same info resides in Column C and D, and if so put a check mark in
Column E.

So in this case I would get an 'OK' for account '123' and '142' but not for
'314' because the date is different and not for 231 because it is missing.

I'm sure its simple enough, I have tried combining and checking, but with
dates it goes wrong....

If you can help I woudl be SO grateful!

Thanks,
Tony

Checking data in 2 columns against a further 2 columns....
 

Try this...

=IF(SUMPRODUCT(--(A$2:A$5=C2),--(B$2:B$5=D2)),"OK","")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"ReallyTallTony" wrote in message
...
I need to check the values of two columns agains another two colums (with
same data) and if they are both in the sheet return a positive result, or
if
wrong return a "Missing Order".

Example:
A B C D
E
SENT Received CHECK
Account Order Date Account Order Date
123 01/12/2009 314 05/12/2009
231 02/12/2009 142 04/12/2009
314 03/12/2009 123 01/12/2009
142 04/12/2009


So I need to take the info from Colum A and B (account and order date) and
see if the same info resides in Column C and D, and if so put a check mark
in
Column E.

So in this case I would get an 'OK' for account '123' and '142' but not
for
'314' because the date is different and not for 231 because it is missing.

I'm sure its simple enough, I have tried combining and checking, but with
dates it goes wrong....

If you can help I woudl be SO grateful!

Thanks,
Tony