Help with Vlookup



In my table array I only have two columns, the first contains percents and
the other contains a letter grade that corresponds to that percent. Such as
100%, A+ (next row) 93%, A )next row) 90%, A-. And so on. My lookup value
cell will sometimes contain a percent that a isnt a solid 93% or 90%. More
like a 92.37% or a 98.12 %. How do I make it so that the Vlookup function
will still pair a letter grade to a percentile that inst necessarily written
in the table array?

Jacob Skaria

Sort that in ascending order as below and use

Col A Col B
90% A-
93% A
100% A+

With lookup value in cell C1 try the below formulas


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads