Column Differences
Closed
cocodemer75
Posts
2
Registration date
Thursday December 1, 2016
Status
Member
Last seen
December 2, 2016
-
Dec 2, 2016 at 04:20 AM
yg_be Posts 22698 Registration date Sunday June 8, 2008 Status Contributor Last seen April 18, 2024 - Dec 2, 2016 at 01:22 PM
yg_be Posts 22698 Registration date Sunday June 8, 2008 Status Contributor Last seen April 18, 2024 - Dec 2, 2016 at 01:22 PM
Related:
- Column Differences
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Excel copy column from one sheet to another automatically - Guide
- How to convert column to row in notepad++ ✓ - Excel Forum
- Macro to compare two excel sheets ✓ - Excel Forum
- How to compare two Excel sheets with varying data ✓ - Excel Forum
1 response
yg_be
Posts
22698
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 18, 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.
