Hi all,
kindly tell me vlookup can replace item if item is differ in invoice data. kindly check attached data to see export in two different system. one is original (main data ) and other from sales tax Data. in this i apply vlookup to find KIP No from main data sheet.
most of time vlookup give N#A its mean single item did not match to main data sheet based on invoice no.
first to check it by invoice then match all item, if any differ to replace by main data sheet auto and find KIP No. ( original Data).
this is sample, original file is more then 20MB. i want to upload but failed.
any body help me?
thanks.
Bookmarks