VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

You can see the key in the table, and VLOOKUP(..., FALSE) still says #N/A. That's almost never a missing row. Exact match compares values, not what the cell looks like. The two usual culprits are a nu