Excel Forum

Excel Magic Trick # 155: VLOOKUP & TRIM function

When the VLOOKUP function should work and it does not, try the TRIM function to get rid of extra spaces. Use VLOOKUP & TRIM together in one formula when the values look the same but there are hidden spaces in the cell.
This trick is good for when you get data dumped into Excel from a database that may have some extra spaces, or when employees add too many spaces during data entry.
VLOOKUP retrieves the value and TRIM gets rid of extra spaces.
Also see: YTLE#70 PivotTable & TRIM function & AVERAGES

Got a Question? Ask it Here in the Forum.