I neeed to merge 16000 rows of data with some duplicate vales. Poor record
keeping lead to two lists and each was updated independantly if at all. Some
orders show up one list and not the other so I can't just sort or do a dup
search. I'm trying to recreate this data and track the status of all orders
for the past 12 months. When orders were shipped out in parts the same order
number was used and this has been a nightmare trying to sort the duplicates
and match the dates.
I need a formula for F that returns the current status based on the order
number and date. I tried a simple vlookup, but it returns the same status for
each order #. I need the order status based on number and date. Please HELP.
A B C D E
F
Order # Date Order # Date Status
433548 4/29/2009 433548 4/29/2009 On hold
433548 5/7/2009 433548 5/7/2009 Shipped in part
433548 5/9/2009 433548 5/9/2009 Shipped full
433601 5/7/2009 433548 5/7/2009 Shipped in part
433665 5/7/2009 433548 5/7/2009 Shipped in part
519080 5/8/2009 433548 5/8/2009 On hold
519080 5/9/2009 433548 5/9/2009 Shipped full