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
Questions about Excel Magic Trick # 155: VLOOKUP & TRIM function
Want more info about Excel Magic Trick # 155: VLOOKUP & TRIM function?
Get free advice from education experts and Noodle community members.