VLookUp Mystery

[rc_schawel]

I tried using the vlookup function but it's returning #N/A and I don't understand why because I tried the same formula on a new worksheet (with made up values) and it works. I wish I could explain it better but I don't know how to attach a snapshot of my screen here.

 

[VoG]

See if this helps http://www.contextures.com/xlFunctions02.html#trouble

 

[rc_schawel]

Ahhh!!! Fixed it! Thanks a lot!

It was because there were spaces in my values so I had to TRIM them.