Hi Guys.

We have a supplier that releases a new price list each month and they have 30,000 items, however we only have 4,000 in use.

They release this data on a spreadsheet and I also have my stock list on a spreadsheet.

There may be an easier way to do it but I was mucking around with VLOOKUP to try and say WHERE BARCODE = BARCODE FIND PRICE COLUM AND UPDATE.

Because the supliers spreadsheet has 30,000 lines and is released everymonth I can't simply just sort by barcode as my 4,000 items dont match up.

See below as an example. Essentially just trying to update 1 Colum where 2 x Barcodes matchup

Capture.PNG