IFS, is there another way?

[SpeaksKM]

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 for every single possibility? The sheet continues down to 25 and I really don't want to have to type all those conditions.

[#2]

@SpeaksKM 

Legacy Excel formula as you did not mention 😞 the version you run

[#3]

@SpeaksKM 

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.

[#4]

@SpeaksKM 

On top of @mathetes' suggestion... With Data Validation ref. to MinScore & MaxScore in the Name Manager - see attached file

Any question feel free to ask