Help with Vlookup
Put your values in ascending order, & set the range_lookup parameter of the
VLOOKUP function to TRUE (or leave blank).
For VLOOKUP, or any other Excel function except DATEDIF, if you need help,
try Excel help.
--
David Biddulph
"ShaneChop" wrote in message
...
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?
|