Hello. I use vlookup formulas but sometimes the reports that are generated have spaces before or after words because the people that generate them are idiots. How do I do a vlookup that ignores the spaces. For example, if I want to lookup "Dogs" and I keep this as my lookup value but the value in the report is "Dogs__" with the line indicating a spaces. Obrigado.