formulas - returning column items that match up?

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

Hi, the LOOKUP command might work

IE it would search column A for the value in column C and return the price found in column B
Assumming starting at A1
Current Cells Value would be C1-C400
=LOOKUP(Current Cells Value,$A$1:$A$800,$B$1:$B$800)

Hope this helps, Let me know if this is not what you wanted.