+ Reply to Thread
Results 1 to 3 of 3

Vlookup fail, plz help!

  1. 01-20-2017, 10:09 PM #1
    gcefaloni
    gcefaloni is offline
    Registered User
    Join Date
    01-09-2015
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    11

    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:
    https://expirebox.com/download/eacc6...95dbbe1a1.html

    Thanks for the help!

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

    Gabriel
    Attached Files Attached Files
    Last edited by gcefaloni; 01-20-2017 at 10:15 PM.
    Reply With QuoteRegister To Reply
  2. 01-20-2017, 10:29 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,232

    Re: Vlookup fail, plz help!

    Use this formula in U2:

    =IFERROR(VLOOKUP(E2,CreditRatingScale!$A$2:$B$23,2,0),"")

    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.

    Pete
    Reply With QuoteRegister To Reply
  3. 01-20-2017, 10:34 PM #3
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1