double match then find out item

Hi all,
i am using a formula but did not get desired result. kindly help me.
see the attached file, highlighted are results but formula is not giving me OK result. there are little bit difference in items based on invoices and qty.
Thanks.

Hi special-K,
please see again attached sheet. items are there in little bit differences. see the pic. actually i want to see the items are mismatch in these invoices.

Hi special-K,
please see the pic. its clear you every thing. if you have required more clarification please tell me.
Thanks.

in this scenario some items are mostly close to each other BUT last word must be different, not possible to perfect match to each other.
See MD-NCEUP4006 last work in OK data sheet MD-NCEU4006X. THIS IS VERY DIFFICULT TO ME HOW TO SETTLE THIS ISSUE. same as top one.

Hi Bo_Ry,
thanks for your reply,
actually theses reports collects from two different system. one is 17-18new sheet and other is OK-DATA sheet. i merge INV + ITEM concentrate formula and apply vlook(b2,ok-data!A2:A50000,4,0) to find KIP No, this main objective. OK-DATA sheet i remove most of column because file is too big so remove merge cell inv + Item in OK-DATA sheet. where this formula break the result is #N/A out of 10000 (item + invoice) cell. its mean 723 item + invoices are not match and did not find KIP No. then i copy only #N/A result in other sheet which i give you.
so i now i check and correct where is a missing in items. to find out KIP. when item will OK then Vlookup find KIP No. this is main problem.
currently i am working on this project. now i apply new formula in new sheet match invoice and item and pick accurate item from OK-DATA sheet, because i have to set 17-18new sheet.
if you have any other idea to solve this issue you can do that, move any column any where, you can do that.
one possiblity in my min d is:
if all 17-18new sheet invoices are match to OK-DATA sheet and remove all other invoices so then it will easy to identify item. OK-DATA sheet invoices are more than 33000.
please see new attached sheet.

invoices can be deleted in OK-DATA sheet quickly with MACRO or other than macro.

SUMIFS can give just ITEM from OK-DATAsheet after matching invoice and qty?

can you tell me why conditional formatting is not working?

Hi AliG,
ok i start a new thread BUT actually this is a part of this.

Hi,
actually both items are different in our inventory system, MD-NCEUP5015 and MD-NCEU5015X is different to each other. cost of both item is differ. KIP No tell me exact cost of item. if wrong item pick the cost will be wrong put. after this i have to add column COST of Item. so this is very important to pick right. i am stuck in this problem because entry are too many 723 invoices problem. manual working is too difficult to set filter and check each item.

Hi Bo_Ry,
criteria is simple, if KIP No is same cost will not change, no effect in costing, when KIP No change then cost change. you can pick any one item after matching Invoice and Qty. Invoice A10033 there are three item Qty 5, BUT KIP No is same, you can pick anyone of them. see the pic

please let me check

can i upload 5 MB file?

You are super, really fantastic job,
i never forget this.
Thanks a lot in my deep heart.
your question is valid, If QTY are the same but different KIP, then what are the criteria? i cannot give any criteria.
after putting the cost value then one more criteria will be there. some items are free of cost. so it is difficult to understand you.
kindly tell me how to add 2 more criteria in this formula.
=LOOKUP(1,1/('OK-DATA'!$B$2:$B$1999=$E2)/('OK-DATA'!$D$2:$D$1999=$I2),'OK-DATA'!C$2:C$1999)
i want add more than 2 criteria, how to add on it.
Add it,
('OK-DATA'!$C$2:$C$1999=$F2)/('OK-DATA'!$G$2:$G$1999=$M2) THEN PICK KIP No- from H:H.
Thanks again BOSS.

Hi Bo_Ry,
Thanks for this.