Vlookup

Hi Susanne,

Thank you for the forum question.


Data can be cleaned using the clean function or extra spaces can be removed if spaces course problems.

If you get hidden characters or leading or tailing spaces from your client system the Vlookup will not work.

The Clean function can remove hidden characters. Add a column next to the column with the imported lookup values. Type =clean(trim(A1)) (A1 only if the first cell you want to clean is A1. Type =clean(trim(C1)) is the first cell you want to clean). And then just copy the clean fuctions down.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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