Update Price List - Match Price & Barcode against another Sheet

[tbgame]

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

[AliGW]

Welcome to the forum!

You don't need the list sorted if the barcodes are unique; you just need to set the final variable in the VLOOKUP to FALSE (or 0) to force an exact lookup. So, in your My Stock - Price column (let's say this is C), try this:

=VLOOKUP(B4,$F$4:$G$50,2,0)

If you can't get it to work, attach the workbook here.

[FDibbins]

Sorting "may" help speed up the lookup, but as Ali pointed out, it is not really necessary. If the vlookup is not working when you KNOW there is a match, test the 2 "matches: to see if they really are the same. Look for leading/trailing spaces, text/numeric entries, test with =exact(cell1, cell2)

[tbgame]

Perfect! Thanks so much for your help that has done the trick!

Cheers.

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.