Using VLOOKUP with letter grades to GPA number

[Sheila3434]

I am using a vlookup table to insert the numerical grade of a letter grade (B+ = 3.27, B = 3, B- = 2.37, etc) for GPA computation. It will only pull the first two grades (B = 3, B+ = 3.27). For the third grade (B-), it inserts the numerical grade for the first grade (B- = 3, not 2.37).

Can you help me figure out how to get this so it will insert the correct numerical grade for the minus (A-, etc) grades? What formula am I missing?

Thank you for any help you can give.

[JBeaucaire]

the first formula in H13 should be: =VLOOKUP(F13,Table1,2,0)


you were missing the 4th vlookup parameter. With 0, the matches are exact and will return the values when exact matches are found.

With 1 or if it is omitted, the matches are "Fuzzy" and are only suited for tables where the search values are sorted correctly. A- and A behave oddly in that scenario. Include the "0" to resolve the issue.

[Sheila3434]

THANK YOU!!!! I did not know to add the 4th parameter. It works like a charm now. (To think I have spent years fussing with this trying to get it to work!!)

I did not know that this site existed; but will not forget it.

[JBeaucaire]

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

[Sheila3434]

Thank you again. I thought I had seen something about marking this as solved; but couldn't locate it. I will know in the future.