V-Lookup

Hi Gary,

Thanks for getting back to me.

Unfortunately spreadsheet A (report I download from Access) does not have the product names. Spreadsheet B is the master sheet.

The only thing these two spreadsheets have in common is the code (actually called HS Code- a 10digit number). On the master sheet the HS Code has an alternative EU Code- which is the code I need my spreasheet A to automatically convert to.

Codes on Master:
Europe Worldwide
Commodity HS Code

7323930000 4911914040
8306290000 8306290000
4820103000 4820102060
4820103000 4820102060


So basically access downloads automatically with the HS Code, and I need to convert it to its related EU Code.

(Sorry for repeating, just want to make sure it is clear for you).

I can re-arrange spreadsheet B (the master sheet)- However am worried a V-lookup might not work, becuause many products may the same HS Code, so it is not unique, though the product code is unique. Also the EU code that I replace the HS Code on Spreadsheet A, the last two digits need to be deleted, because only 8 digits can be accpeted.

Also are you able to elaborate a little by what you mean by a "helper" column? Thanks so much.