Ok, here is what I eventually came up with.

Someone on VBforums.com suggested using this VLOOKUP formula:
=VLOOKUP(A1,Sheet2!$A$1:$B$1000,2,FALSE)

These were the steps I needed to take:

1. Made a new column (C) in sheet1 with the lookup formula to show ne
prices against the old.

2. In column D I put another formula to show differences in price
=C1-B1

When comparing the two sets of data using the VLOOKUP shown above, thi
is what comes up:


ITEM1 2 1.75 -0.25
ITEM2 7.7 6.8 -0.9
ITEM3 4 4.5 0.5
ITEM4 5.1 #N/A #N/A
ITEM9 11.5 11.5 0

Now, I would just need to have something run down column D, look fo
any value that is not #N/A or 0 and copy the item number and new pric
down to a new sheet for that row. Is this easily done?

Thanks

--
Message posted from http://www.ExcelForum.com