Vlookup returning N/A except for three cells

[TMAZZ]

I have the first two columns setup as table 3, 

I'm doing a simple vlookup and the formula is only returning three cells with details, doesn't make sense the formatting is all the same. What is going wrong?

See attachment

[#2]

Hi @TMAZZ,

The data in column C isn't clean, it contains many leading spaces!

You need to clean these spaces using TRIM function. I've done that for you in the attached file.

Hope that help