Hi! Can anyone help me out with this…I believe I need assistance with some formulas to make this happen…
Company ABC product codes are listed in Column A, prices in B…approx 800 in list
Company XYZ product codes are in Column C, prices in D…approx 400 in list
Both companies have the same product codes, but XYZ does not use the ALL the products ABC does so these lists are not identical.
I need help figuring out what formula(s) might search Columns A & C and find matches…and then in a new set of columns return the results so I can use an “if” formula to notify me when the prices do not match up for both companies. (I know the “if” formula already….it’s getting the info over to a new set of columns I am in need of assistance on.)
If this is unclear please let me know!
Can anyone help me with this please??
Greatly appreciated!
Jenny
Bookmarks