Excel File: https://www.teachexcel.com/excel-tutorial/2056/5-bite-size-vlookup-tricks-for-excel?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

5 tricks for using Vlookup on data that might not always be ‘friendly.’

This includes:
Removing extra spaces.
Working with multi-part lookup values.
Dealing with Vlookup errors.
Removing extra characters.
Fixing Text/Number value issues.