If they are 3 different tables, you can look up the grade in each table with an if statement:

=if (type=AP, vlookup(… AP table), if(type=Honors, vlookup(…Honors table), and so on.

Or, you could have one table, where 85 for example, converts to a different grade depending on AP, Honors, etc.

– in this case, you can determine which column in the table to look in based on which type of course it is. For example:

=VLOOKUP(B2, $G$1:$K$10, C2, TRUE)

– B2 is the numerical grade you’re looking up

– $G$1:$K$10 is the table with the grades

— G1-G10 has the numerical grade thresholds

— H1-H10 are the corresponding letter grades for AP

— I1-I10 are the letter grades for Honors, etc.

– C2 is the offset, and it would be set to 2 for AP (since AP is the second column in the table), 3 for Honors, etc.

– so if C2 is 2 it will look in col. H to get the grade, for example

If you need more info, please add detail or e-mail.

Good luck.

.