Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |