This video explains how to fix a Vlookup space issue in Microsoft Excel

How to fix a vlookup when the lookup value has a space in it. The tutor demonstrates how to create a simple lookup formula in Microsoft Excel. The tutor then explains what can go wrong when the lookup source data has a space in front of the lookup value. The tutor mentions that the trim function will not work in the example shown. The video covers how to concatenate a wildcard symbol into the vlookup formula, which will pick up any spaces and return the correct value. This is a Microsoft Excel tutorial covering, vlookup, trim function, concatenation and how to work around spaces in source data. Remove blank spaces in Excel formulae

Playlists for this channel:

#itseasytraining

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books

Excel for New Managers

Very cheap E_books are here:

[Annivlogs]

Sir you must zoom the sheet for better view