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.
I hope I am understanding correctly. You have POs in the PO file that may not be in the PM or Incentive file. I used the Index/Match function in two columns in the PO file to search the PM and Incentive file to determine which items are missing.
In a column for searching the PM sheet from the PO sheet =INDEX(PM!A:A,MATCH('PO STATUS'!A2,PM!A:A,0))
In another column on the PO sheet to search the Incentive sheet =INDEX(INCENTIVES!A:A,MATCH('PO STATUS'!A2,INCENTIVES!A:A,0))
and then each is copied down. When an NA appears, it means it was not found in the search.
I have attached your worksheet back with these formulas in them.
That worked perfectly thank you! Now I have a different question. Would I be able to throw an "IF" function in front of it so if there is nothing in the column to read or it does not match it will just be blank instead of N/A and it still work properly? It would make it easier on the eyes to look at, if not its ok, just curious.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks