## 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)