vlookup numbers to alfebets

Posted on 2011-10-06
Last Modified: 2012-05-12

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
Question by:csharp_learner
    LVL 20

    Expert Comment

    by:Hendrik Wiese
    Add this to F2:


    Open in new window

    LVL 20

    Accepted Solution

    Sorry here is the correct one:


    Open in new window

    LVL 20

    Expert Comment

    by:Hendrik Wiese
    Here is the edited copy if you want to download it.


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now