Forum Discussion
IFS, is there another way?
To weight tests I have this sheet of composite scores that correspond to a test grade. Is there a way to enter a student's composite score and have Excel spit out the grade without doing IFS f...
A variation on the formula from Lorenzo
This is the formula, which uses INDEX and MATCH instead of VLOOKUP.
=IFERROR(IF(ISBLANK(G2),"Enter Score Above",INDEX(Table1[Grade],MATCH(G2,Table1[Score],0))),"Score Out Of Range")
You would do well to familiarize yourself with the various ways Excel accommodates looking up data from a table. Any time there's the temptation to do many levels of IF (with lots of possibilities) it's likely that a table lookup will serve the purpose, and Excel offers multiple ways to do that.