Vlookup

[ptrembla]

Hello,

I have a hard time making my Vlookup to work....I only get #N/A

here's a picture of what I try to do

Snap5.jpg

my data report is column Y.

I received a list with codes and descriptions to match with column Y (Columns Z and AA)

I want to add description to codes in column Y, so I want to read "Strat Policy Planning..." in column AB

thank you!

[judgeh59]

my guess be that the number in Y1 isn't a number since it's left justified and has a carat in the upper left corner...convert that to a number and the VLOOKUP Should work...

[judgeh59]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title.

[ptrembla]

Looks like it's working...I always forget the formatting....

AWSOME!!!! THANKS!!!

[judgeh59]

no problem. Glad I could help...

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...