Column Differences
Closed
cocodemer75
Posts
1
Registration date
Thursday December 1, 2016
Status
Member
Last seen
December 2, 2016
-
Dec 2, 2016 at 04:20 AM
yg_be Posts 23494 Registration date Sunday June 8, 2008 Status Contributor Last seen March 24, 2025 - Dec 2, 2016 at 01:22 PM
yg_be Posts 23494 Registration date Sunday June 8, 2008 Status Contributor Last seen March 24, 2025 - Dec 2, 2016 at 01:22 PM
Related:
- Column Differences
- How to delete column in word - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- Excel vba find last non empty cell in column - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 response
yg_be
Posts
23494
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 24, 2025
5
Dec 2, 2016 at 01:22 PM
Dec 2, 2016 at 01:22 PM
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.
=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.
