Crosschecking data

**tmozza** · 02-04-2010, 12:59 PM

Hi Everyone!

Got a bit of a complicated one so any help would be greatly appreciated!

Basically, I have two sheets of data... each contain a unique item number and a price of this item.....

I want to compare the data to firstly make sure that the unique number is on both sheets and if it is I want it to ensure the prices on both sheets are the same.

Can anyone help?

Many Thanks

**JBeaucaire** · 02-04-2010, 01:07 PM

Column A contains IDs
Column B contains prices
Row1 is titles, so list actually starts at row 2

On sheet1, put this formula in C2 and copy down as far as needed:

=IF(ISNUMBER(MATCH($A2, Sheet2!$A:$A, 0)), IF(INDEX(Sheet2!$B:$B, MATCH($A2, Sheet2!$A:$A, 0)) = $B2, "Good", "Price Different"), "Product Missing")

On sheet2, put this formula in C2 and copy down:

=IF(ISNUMBER(MATCH($A2, Sheet1!$A:$A, 0)), IF(INDEX(Sheet1!$B:$B, MATCH($A2, Sheet1!$A:$A, 0)) = $B2, "Good", "Price Different"), "Product Missing")

**Richard Buttrey** · 02-04-2010, 01:09 PM

Hi,

With Item numbers in A and prices in B in both sheets, use

Please Login or Register  to view this content.

and copy this down. Where it returns #N/A it means the item number doesn't exist.

HTH

**tmozza** · 02-05-2010, 11:23 AM

thanks guys, it really helped!

**JBeaucaire** · 02-05-2010, 11:46 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)