Excel File: Excel Forum: 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.