vlookup numbers to alfebets

Hi,

I am trying to use the vlookup function to return the respective Alfebets accorddly.
Eg. In the attached vlookup.xls Alan is 1 hence in Column F should return an A
and Peter got 2 hence in the F column should return B and subsequently John should return G

Can any experts help me out on this?

*I am using excel 2003
vlookup.xls
csharp_learnerAsked:
Who is Participating?
 
Hendrik WieseInformation Security ManagerCommented:
Sorry here is the correct one:

=VLOOKUP(E2,A2:B17,2,TRUE)

Open in new window

0
 
Hendrik WieseInformation Security ManagerCommented:
Add this to F2:

=VLOOKUP(E2,A2:A17,1,TRUE)

Open in new window

0
 
Hendrik WieseInformation Security ManagerCommented:
Here is the edited copy if you want to download it.

vlookup.xls
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.