Trouble using the vlookup function

'm having trouble using the vlookup function, I have calculated a final numerical grade for a hypothetical course, and and trying to use a set of numerical grades with their corresponding letter grades to get a vlookup function to return the letter grade from the numerical grade.
Screen Shot 2019-01-29 at 6.16.48 PM.png
However the function for some reason only returns the lowest value out of the set grades, not the closest match.
Screen Shot 2019-01-29 at 6.45.25 PM.png

If you use TRUE as the 4th parameter in VLOOKUP, the data has to be sorted in ascending order - yours is sorted, but in descending order.

You can sort the data in J3:K23 so that it is in ascending order, and your VLOOKUP formula will work, or you could leave the lookup table as it is and use INDEX/MATCH instead, like this:

=INDEX(J$3:J$23,MATCH(C29,K$3:K$23,-1))

Hope this helps.

Pete

Thanks for the rep - I presume one of the methods worked for you.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete