Compare columns across two sheets

[Richard Michael Duffy]

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

PRODUCTNA DESCRIPTION SIZERANGE TNF0690 LONGHAUL 26 Z SAL0780 SUSPECT171 Z LYO020 ECRIN ROCK HELMET Z
Sheet 2 A B C PRODUCTNA DESCRIPTION REMARK DCS0019 STYRO JKT TNF0690 LONGHAUL 26 SAL0464 ARC JKT W11 x SAL0780 SUSPECT 171 BRA0003 COUNTRY MASTER GTX SHOE x BRA0004 HILLMASTER GTX LADY BOOT x <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks,
Rich.