VLOOKUP not working

VLOOKUP not working - please check and explain why this is not working.

see attachment
Who is Participating?
ste5anSenior DeveloperCommented:
It works. So what is your question?

The value from your column Y must be in the first column of the lookup range, but there is only a 1.
From your example I cannot tell, in which column of your lookup table this number should be found.
The column index number parameter is the column of the return value,

Some of your values are formatted as text some as numbers if they are all the same it should solve the problem

ssblueAuthor Commented:
ok I now understand. I wasn't getting what I needed and I couldn't figure out why. I didn't realize that the value from my column Y must be in the first column of the lookup range and then the formatting was giving me a problem also. Thanks for the information.
ssblueAuthor Commented:
How can I make formatting changing. It doesn't seem to take the formatting changes and things work correctly???
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.