Column Differences [Closed]

Report
Posts
2
Registration date
Thursday December 1, 2016
Status
Member
Last seen
December 2, 2016
-
Posts
15201
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 16, 2021
-
Hi.
Thanks for welcoming me to this forum. I have a problem and I am hoping someone here can help me.
The problem is as follows:

I have 2 worksheets.
There are around 36000 rows of products on each sheet, although the sheets are not an exact match ie there are some products which appear only on sheet 2, and same on sheet 1.
Each product has a unique barcode to identify them, shown in column 1 on both sheets.
On Sheet 1, the barcoded products have a RRP in column 2
On Sheet 2 the barcoded products have an up to date RRP in column 2
I need to compare the two sheets to pull out the products whose RRPs have changed between sheet one and sheet 2, where the barcodes are the same.
Would anyone please be able to tell me how?
I look forward in advance to your response
Kind regards
Colin

1 reply

Posts
15201
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 16, 2021
4
One way to do it is to store this formula in second line of third column of sheet 1:
=VLOOKUP(A2;Sheet2!A$2:Sheet2!B$36000;2;FALSE).
Update the value 36000 in the formula, to be sure you look into all values of sheet2.
Then copy that formula down in third column, till the end of your data.
After that, you can compare as you want (using a simple formula), for each product, the original RRP in colum A and the updated RRP in column C.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!