+ Reply to Thread
Results 1 to 3 of 3

Vlookup fail, plz help!

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Vlookup fail, plz help!

    Hi guys,

    I'm trying to do a vlookup that looks at different letter ratings (AAA,+AA,AA,AA-,A+,A,A-,etc.) and give that letter rating a numeric value from 0 to 100 that is in an array in another worksheet. But for some reason, my vlookup doesnt seem to recognize the letter rating either in the main worksheet or in the reference table with the numeric scale in it. I'm not sure whats wrong. Please help!

    I've attached my 2 worksheets in the following example:

    Thanks for the help!

    P.S. The Vlookup is in column U of the spreadsheet

    Attached Files Attached Files
    Last edited by gcefaloni; 01-20-2017 at 10:15 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)

    Re: Vlookup fail, plz help!

    Use this formula in U2:


    Notice that I have changed the 2 that you had at the end of the formula to a zero, as well as wrapping IFERROR( ... ,"") around the formula to avoid errors.

    Hope this helps.


  3. #3
    Banned User!
    Join Date
    San Escobar
    MS-Off Ver
    any on PC except 365

    Re: Vlookup fail, plz help!

    I think OP should first learn the definition of VLOOKUP():

    =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make a cell display "FAIL" when range of cells is FAIL
    By crazychile in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2017, 04:13 PM
  2. [SOLVED] VLOOKUP to summarize most recent year and pass/fail result.
    By DocPickles in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2016, 05:22 AM
  3. [SOLVED] VLookup Fail
    By morerockin in forum Excel General
    Replies: 8
    Last Post: 11-11-2015, 10:16 AM
  4. VLOOKUP fail to find a number in a list in Excel
    By oyz79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2015, 05:54 PM
  5. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  6. [SOLVED] Vlookup begins to fail after so many cells
    By calee1983 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2013, 01:33 PM
  7. why does this fail?
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2005, 08:06 AM

Tags for this Thread


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