I have a excel spreadsheet with my inventory on it. Every day I receive a updates from my supplier that has all the current item #‘s. So this means item #‘s are no longer there because they go out of sock and new # ‘s appear for new products.. The number do not match up just by sorting them. I’m looking for a formula in excel to help me match up my item # ‘s with my suppliers # ‘s.. I know excel has formulas but I do not know how to work it...
Column A supplier item #'s to match column B my item #'s..
Column A supplier item #'s to match column B my item #'s..