Richard Michael Duffy
New Member
- Joined
- Jul 10, 2012
- Messages
- 6
Hi,
I have data on two sheets. The first column of both sheets has a product reference. The data has not been sorted by this reference but can be if needed. Sheet2 has 14,000 rows and a column with a remark "x" that I want to display in sheet1 if the product reference matches. I've tried reading some tutorials on vlookup but have not had any success getting this to work. Can anyone help me please? If anyone can I have pasted an example of sheet1 and sheet2 below
Sheet 1
A B C
[TABLE="width: 384"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]PRODUCTNA DESCRIPTION SIZERANGE
TNF0690 LONGHAUL 26 Z
SAL0780 SUSPECT171 Z
LYO020 ECRIN ROCK HELMET Z[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
Sheet 2
A B C
[TABLE="width: 405"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]PRODUCTNA[/TD]
[TD]DESCRIPTION[/TD]
[TD]REMARK[/TD]
[/TR]
[TR]
[TD]DCS0019[/TD]
[TD]STYRO JKT[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TNF0690[/TD]
[TD]LONGHAUL 26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAL0464[/TD]
[TD]ARC JKT W11[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]SAL0780[/TD]
[TD]SUSPECT 171[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRA0003[/TD]
[TD]COUNTRY MASTER GTX SHOE[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]BRA0004[/TD]
[TD]HILLMASTER GTX LADY BOOT[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
Rich.
I have data on two sheets. The first column of both sheets has a product reference. The data has not been sorted by this reference but can be if needed. Sheet2 has 14,000 rows and a column with a remark "x" that I want to display in sheet1 if the product reference matches. I've tried reading some tutorials on vlookup but have not had any success getting this to work. Can anyone help me please? If anyone can I have pasted an example of sheet1 and sheet2 below
Sheet 1
A B C
[TABLE="width: 384"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]PRODUCTNA DESCRIPTION SIZERANGE
TNF0690 LONGHAUL 26 Z
SAL0780 SUSPECT171 Z
LYO020 ECRIN ROCK HELMET Z[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
Sheet 2
A B C
[TABLE="width: 405"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]PRODUCTNA[/TD]
[TD]DESCRIPTION[/TD]
[TD]REMARK[/TD]
[/TR]
[TR]
[TD]DCS0019[/TD]
[TD]STYRO JKT[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TNF0690[/TD]
[TD]LONGHAUL 26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SAL0464[/TD]
[TD]ARC JKT W11[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]SAL0780[/TD]
[TD]SUSPECT 171[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRA0003[/TD]
[TD]COUNTRY MASTER GTX SHOE[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]BRA0004[/TD]
[TD]HILLMASTER GTX LADY BOOT[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
Rich.