Vlookups when the Lists aren't Identical

Hello,

Apologies if I've posted in the wrong thread - I think I've picked the correct one.

I'm currently working on a project where I need to compare lists of product names and then vlookup them so that I get their barcodes. The problem I've been having, however, is that a lot of companies like to rename our products - for example 'Vitamin C' is often chanced to 'Vit C'. Is there a way that I can still Vlookup (or whatever function it may be - or even macro) and match them to the correct barcode please?

Many thanks for your help.

Can you provide some sample data and what the expected outcome is?

Excel Image.jpg

I can't send the real documents because I'll get sacked - but it's along these lines - the products are identical and have the same barcode they merely differ in what company 1 has described them as.
Thus I'm attempting to Vlookup to find the correct barcode but it doesn't work because the two descriptions differ - and there's 400 odd rows of this so doing it manually would be far from efficient. Thanks.

Please find the attachment attached below - I think it should be there

Can you post price ?

I have added some prices - unsure of the actual prices so just made some up.

i prefer to make macro to find and replace Vit C become Vitamin C.
so vlookup will work.
sorry i'm newbie

Thanks for the help everyone - Fuzzylookup has worked well