Match barcode between 2 sheets
Solved/Closed
Ram
-
Feb 15, 2012 at 07:03 AM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Match barcode between 2 sheets
- Excel formula to find matching text in 2 columns - Guide
- Excel compare 2 sheets - Guide
- Compare 2 Sheets -> Summary differences ✓ - Forum - Excel
- Highlight unique or duplicate on 2 sheets ✓ - Forum - Excel
- Excel - Removing different rows in 2 sheets ✓ - Forum - Excel
1 reply
TrowaD
Feb 16, 2012 at 10:32 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 16, 2012 at 10:32 AM
Hi Ram,
Looks like you are in need of the VLOOKUP formula.
=VLOOKUP(1,2,3)
1: the cell/value you want to lookup. The barcode from sheet2
2: the matrix you want to look in. All the data from sheet1
3: the column you want to retrieve info from. For description 2, for quantity 3.
Select the matrix in the formula and hit F4 to make the reference absolute, do this for easy dragging.
Please post back if you get stuck (or to say thank you).
Best regards,
Trowa
Looks like you are in need of the VLOOKUP formula.
=VLOOKUP(1,2,3)
1: the cell/value you want to lookup. The barcode from sheet2
2: the matrix you want to look in. All the data from sheet1
3: the column you want to retrieve info from. For description 2, for quantity 3.
Select the matrix in the formula and hit F4 to make the reference absolute, do this for easy dragging.
Please post back if you get stuck (or to say thank you).
Best regards,
Trowa
Dec 11, 2012 at 09:12 PM
Dec 13, 2012 at 10:45 AM
It is possible to change color of newly added values.
More info is needed though.
What will the destination be for the barcodes (example column A)?
Do you want to color cell or letters?
To get you started, the following code will color the cell red whenever a value is added in column A:
To use code, right-click on the sheets tab (name) and select view code. Paste code and try it out.
Best regards,
Trowa