Vlookup fail, help me!

[gcefaloni]

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/eacc68368064994beb29db995dbbe1a1.html

Thanks for the help!

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

Gabriel

 

[Trebor76]

Hi Gabriel,

The range_lookup argument of a VLOOKUP formula can only be TRUE or 1 or FALSE or 0. You have 2 so that's throwing the formula out. Also a number of cells in Col. E are blank so that will return an error for exact matches.

Put this formula in cell U2 (good name for a band )...

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

...and copy it down to cell U51.

Regards,

Robert

 

[gcefaloni]

Thanks a lot Robert, that worked well.

 

[Trebor76]

You're welcome