G
Guest
Hello everyone. I need help! What I need is a VLookup formula to insert a
letter grade into the last column on the second worksheet. Thank you!
Elizabeth
The following is on worksheet 1
Column A Col B
0 to 49 F
50 to 59 D
60 to 74 C
75 to 89 B
90 to 100 A
The following is on worksheet 2
Student ID Exam 1 Exam 2 Final Overall Grade
318-84-6039 100 93 79 87.75
332-03-6854 99 90 74 84.25
341-38-6902 63 51 43 50.00
362-80-6830 65 91 81 79.50
351-25-6606 74 65 58 63.75
303-86-6698 74 63 63 65.75
360-99-6115 63 50 43 49.75
342-45-6149 84 72 65 71.50
360-49-6615 78 65 58 64.75
331-38-6683 88 78 77 80.00
337-55-6535 72 64 62 65.00
300-60-6949 100 89 85 89.75
373-46-6412 99 88 84 88.75
397-44-6180 98 84 84 87.50
398-56-6736 100 92 86 91.00
letter grade into the last column on the second worksheet. Thank you!
Elizabeth
The following is on worksheet 1
Column A Col B
0 to 49 F
50 to 59 D
60 to 74 C
75 to 89 B
90 to 100 A
The following is on worksheet 2
Student ID Exam 1 Exam 2 Final Overall Grade
318-84-6039 100 93 79 87.75
332-03-6854 99 90 74 84.25
341-38-6902 63 51 43 50.00
362-80-6830 65 91 81 79.50
351-25-6606 74 65 58 63.75
303-86-6698 74 63 63 65.75
360-99-6115 63 50 43 49.75
342-45-6149 84 72 65 71.50
360-49-6615 78 65 58 64.75
331-38-6683 88 78 77 80.00
337-55-6535 72 64 62 65.00
300-60-6949 100 89 85 89.75
373-46-6412 99 88 84 88.75
397-44-6180 98 84 84 87.50
398-56-6736 100 92 86 91.00