V Look Up
When using V lookup on Excel, I am trying to match an inventory however when using V lookup it will not match all barcodes even though they are there to be matched. I think it is to do with the formatting of the cells are different but when changing them to the same formatting it will still not find them with V look up. Any help would be great please.
RE: V Look Up
Hi Stephanie,
Thank you for the forum question.
Your problem is probably spaces or hidden characters.
Try to add the trim and clean function to your Vlookup.
=Vlookup(Trim(clean(A2)), Table array, Column number, range lookup)
I just added A2 to my example you need of course to use you cell reference.
Let me know if this do the job.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
