I have this spreadsheet that merges onto a Transcript in Word€¦.We have
Student Names, Class Dates, Grades for Classes per Terms, etc.€¦.They have
been manually figuring the GPA,,,,I set up some formulas that has helped, but
need help on the more difficult ones€¦.someone helped me last week with the
following formula (finding and matching the Grade to return a GPA.
THANKS€¦€¦.Now I have been asked to find and match the Grade or GPA and return
a Ltr Grade on the Transcript as well and I need help again€¦..

The following formula matches the Grade to the GPA:

formula is: =SUMPRODUCT(--($AR$2:$AR$37=D3),$AS$2:$AS$37)

I tried using the same formula, just changing the Column numbers, but it
didnt work€¦Can you help me? I dont know if the problem is number to
text€¦.(numeric to alpha)

lookup table sample is:

AR AS AT
Grade GPA Ltr Grade
2 100 4.0 A
3 99 4.0 A
4 98 4.0 A
5 97 4.0 A
6 96 3.7 A-
7 95 3.7 A-
8 94 3.5 B+
9 93 3.5 B+
10 92 3.0 B
11 91 3.0 B
12 90 3.0 B
13 89 2.7 B-
14 88 2.7 B-
15 87 2.7 B-
16 86 2.5 C+
17 85 2.5 C+

Please write back.....
Thanks,
Cindy