Forum Discussion
JKPieterse
Oct 31, 2023Silver Contributor
Place your limits in a small table, for instance like this:
A | B | |
1 | 4 | a |
2 | 5 | b |
3 | 8 | c |
4 | 11 | d |
5 | 14 | e |
Suppose your grade is in cell C1, then this formula gets the letter belonging to that grade:
=XLOOKUP(C1,$A$1:$A$5,$B$1:$B$5,"NA",1,)
- SM258Oct 31, 2023Copper ContributorDon't really understand how to use the formula ... nor how to make the small table correspond with the betweens i'm aiming at
- JKPieterseOct 31, 2023Silver ContributorThe betweens are automatically catered for by this formula.
- Vinod2406Oct 31, 2023Brass ContributorTo help people who Search you can click on Mark as solution at the bottom of the post (the one with the solution you adopted)