After all has been said and done, I found this formula to work very well for
your actual setup:

=IF(ISNA(MATCH(A2,'IFC PRICE 2008 NEW'!A:A,0)),"No UPC
Match",IF(G2=INDEX('IFC PRICE 2008 NEW'!G:G,MATCH(A2,'IFC PRICE 2008
NEW'!A:A,0),0),IF(H2=INDEX('IFC PRICE 2008 NEW'!H:H,MATCH(A2,'IFC PRICE 2008
NEW'!A:A,0),0),IF(ISNA(VLOOKUP(A2,'IFC PRICE 2008 NEW'!A:M,13,FALSE)),"No UPC
Match",VLOOKUP(A2,'IFC PRICE 2008 NEW'!A:M,13,FALSE)),"Size (W)
Mismatch"),"Size (L) Mismatch"))

That was placed in row 2 and filled to the end of your data area. The
workbook you sent me has been returned with the changes made along with an
explanation.

"fitzsociety" wrote:

I am working on matching upc numbers from our vendor with our companies part
numbers. I have started working on this for a few months but half way the
new prices for 2008 have been downloaded and I have no idea how to take the
prices from another worksheet and match them to the worksheet I have now.
Each price can be referenced with a unique upc number.
--
Mike Fitz