↓ Skip to main content
Amit Kohli
  1. Data in the Real World/
Track A Episode #20

This is why your VLOOKUP isn't working

Data in the Real World
Watch on YouTube View LinkedIn post

Your VLOOKUP returns #N/A even though the value is right there. The culprit is a trailing space you can’t see. TRIM() fixes it - but the real question is where that space came from in the first place. Web forms, legacy systems, copy-paste from Word. The data is telling you something about its own provenance.