When VLOOKUP Does Not Match
Key points
- Paste the text
- Clean it
- Try again
Removing invisible characters and extra spaces with Excel Text Cleaner can make values match.
Steps
- Paste the text
- Clean it
- Try again
Also try the setting that turns full-width spaces into normal spaces.
Use "Remove Extra Spaces and Invisible Characters from Excel Text" (free)
Tools that go well with this
- Convert Full-Width, Half-Width, Hiragana and Katakana: Convert full-width/half-width and hiragana/katakana.
- Remove and Tidy Line Breaks in Text: Tidy line breaks in text copied from PDFs and elsewhere.
- Remove Duplicate Lines and Sort a List: Remove duplicate lines and sort them.