How to Match Values Between 2 Sheets & Copy Corresponding Data ?

I have a sheet (SHEET1) with a EAN code and a empty column I need to get a colour into from sheet 2.

I have to match EAN codes in Sheet 1, (Column X) with Sheet 2(Column E) and then pull the description from the corresponding row in Sheet 2(Column D).

I am sure I can use the VLOOKUP formular but I dont know how to input the code?

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Any help appreciated!!

I made it a little easier but still can not get it to work!

I need the Value in column X to be matched with column AQ (AQ6:AQ13555) and need the function to retrieve the description of the corresponding row in column AR (AR6:AR13555)

=VLOOKUP(X6;AR6:AR13555;AR6:AR1355;FALSE)

Please !!