[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

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
0
csharp_learner
Asked:
csharp_learner
  • 3
1 Solution
 
Hendrik WieseCommented:
Add this to F2:

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

Open in new window

0
 
Hendrik WieseCommented:
Sorry here is the correct one:

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

Open in new window

0
 
Hendrik WieseCommented:
Here is the edited copy if you want to download it.

vlookup.xls
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now