Comparing to unsorted lists

[footballking]

Hi All,

Sorry this is probably a really basic question, but i'm struggling a little.

I have two work sheets. Both worksheets contain 2 columns. Column A is a product number; Column B is a price. Using the product name on sheet 2, i would like to compare the price of the products on sheet 2 with the price of the products on sheet 1.

Sheet 2 may have more products on it than sheet one, so the sheets don't match row for row.

Is there a simple way that i can identify any prices of any product on sheet 2 that doesn't match the price of the product on sheet1?

Any help would be appreciated.

Regards,

[Kaper]

using VLOOKUP function you can do this easily (set 4th parameter to FALSE )

if such a tip is not enough, check here: http://www.excelforum.com/forum-rule...rum-rules.html how to attach sample file.

[footballking]

Hi Kaper,

Thank you for taking time to help. I have attached a very stripped down version. Basically i want to to ensure the price for each product number between the worksheets are the same (or highlight the differences). In my example, the columns are sorted, but i need to allow for the fact that the sheets aren't identical.

Thanks!

[Pete_UK]

Put this formula in C1 of Sheet2:

=IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"not found",IF(VLOOKUP(A1,Sheet1!A:B,2,0)=B1,"same","different"))

then copy down.

Hope this helps.

Pete

[footballking]

That's perfect. Thank you for you help