+ Reply to Thread
Results 1 to 2 of 2

vlookup formula not working currectly

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    44

    vlookup formula not working currectly

    im trying to get a vlookup formula work for some grades which converts the letter grades into a number. once i completed this i can then creat a graph from the number that the vlookup gives me however this is not working. i have attached the spreadsheet and the page you need to look at is the processing page. the cell is highlited in yellow to show the formula which is wrong i have another vlookup very similar which works however this one im tryna work just wont. Final system V8.1.xlsx

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,848

    Re: vlookup formula not working currectly

    Your link is incorrect, please remove the extra "/".

    VLOOKUP has a fourth argument that you need to add if your data is not sorted, and yours is not. Use this formula:

    =VLOOKUP(A32,graphdata,2,FALSE)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1