Need Function to search columns and return a value.

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,

Hello there,

Try the following in cell E1

=IF(VLOOKUP(A1,C:D,2,FALSE)-B1<>0,"YES","")

You could copy this formula down to the last row of your data.

Originally Posted by rvasquez

Hello there,

Try the following in cell E1

=IF(VLOOKUP(A1,C:D,2,FALSE)-B1<>0,"YES","")

You could copy this formula down to the last row of your data.

THis is exactly what I needed. Thanks to you both for your time.

Glad to help! Don't forget to mark this thread solved and possibly give a little star tap if I helped.

Thanks!

@ SirDrums

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.