VLOOKUP not working

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

see attachment
vlookup-test.xlsx
ssblueAsked:
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,
0
 
Rgonzo1971Commented:
Hi,

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

Regards
0
 
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.
0
 
ssblueAuthor Commented:
How can I make formatting changing. It doesn't seem to take the formatting changes and things work correctly???
0
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.