mardi 7 avril 2015

Match 2 sets of data and pull back another value in table

I have an excel spreadsheet that contains main UPC numbers and a set of sub numbers that correlate to it.


The first column contains the main UPC numbers. In the 2nd column are items that go in the kitchen, the 3rd and 4th columns contains the numbers that belong on the store floor. 5th column are the numbers actually delivered by the suppliers to the kitchen and 6th numbers delivered to the kitchen.



UPC Number Kitchen Floor Kitchen Delivery Floor Delivery
800503034 6744025 5862250 - 6744025 5862250
877389885 6748626 7737406 - 6748626 7737406
800644104 6749799 5862480 - 6749799 5862480
866918159 6744817 - 9345342 6749817 6745322
866430741 6744022 - - - -


What I primarily want to do is find the deliveries that were done correctly. That is where column 2 matches column 5 and either column 3 or 4 match column 6 and then put the main UPC number (column 1) in sheet 2, row A1.


For example, I want in sheet 2, row A1:



800503034
877389885
800644104


Eventually, I want to be able to find which number is different and where items weren't delivered but I believe this will give me a good start.


Thanks.


Aucun commentaire:

Enregistrer un commentaire