I am trying to figure out if there is anyway to use a formula to find which item # isnt matching in a huge list of item #'s.
In the attached Workbook there is a small sample of what we use to track our PO's now we paste a list that is sent to us in our PO Status column.
It is then pulled to our PM and Incentive Tabs and placed in the China Column using a formula. Every now and then the company we work with's SS's aren't the same as ours(Typo somewhere).
So when I paste some of the quantities are not being totaled up in the China column to match whats in the PO Status tab. I would love if there was a formula to help me find this Item faster instead of searching one item at a time.
Bookmarks