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 23338 Registration date Sunday June 8, 2008 Status Contributor Last seen November 19, 2024 - Dec 2, 2016 at 01:22 PM
yg_be Posts 23338 Registration date Sunday June 8, 2008 Status Contributor Last seen November 19, 2024 - Dec 2, 2016 at 01:22 PM
Related:
- Column Differences
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Excel count occurrences of string in column - Guide
- Excel copy column from one sheet to another automatically - Guide
- Excel vba find last non empty cell in column - Guide
1 response
yg_be
Posts
23338
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
November 19, 2024
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.
