I am trying to match data from two worksheets in excel. I am unable to attach an example due to the size of the file. I have order #'s with different item # and locations. i want to be able to look up the location based on the order # and item #. Here is what my sheet looks like. I hope i explained that correctly, any suggestions would be great.
Sheet 1 sheet 2
A B C D E F G I A B C
Order # Item # Delivery # Departure Date Pick list Print Date QTY Customer Locator Item # Location Order #
0010809318 77-27606 841881 6/17/2013 6/13/2013 280 Amazon 77-18585 DISTY0410 835258
0010809318 77-27492 835258 6/17/2013 6/11/2013 24 Amazon 77-22157 DISTY0110 835258
0010809318 77-27772 835258 6/17/2013 6/11/2013 144 Amazon 77-27492 835258
0010809318 77-22157 835258 6/17/2013 6/11/2013 24 Amazon 77-27606 SHIP05 841881
0010809318 77-21742 835258 6/17/2013 6/11/2013 24 Amazon
0010809318 77-19010 835258 6/17/2013 6/11/2013 24 Amazon
0010809318 77-18978 835258 6/17/2013 6/11/2013 24 Amazon
0010809318 77-18585 835258 6/17/2013 6/11/2013 456 Amazon
Bookmarks