View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneChop ShaneChop is offline
external usenet poster
 
Posts: 3
Default 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?