Hello,

I have 4 columns 1st contains numbers, the 2nd contains dates

The 3rd and 4th columns contains numbers and dates as well.


I would like to compare the sets of two columns to one another.


For example.

Column 1 row 1 contains 1234
Column 2 row 1 contains 1-11-11

Column 3 row 25 contains 1234
Column 4 row 25 contains 2-15-99


So the formula would find the matches between column 1 and 3 and then tell the user if there is a differnce in the dates in columns 2 and 4. In this case it would place YES in a new column (I guess column 5)

Can this be done or do I need to look into VBA?

Thanks,