Use a vlookup function to calculate the letter grades from D4 to D18, based on the marks earned in C4 down to C18. Also use a vlookup function to calculate the Grade Description from E4 to E18, based on the marks earned in C4 down to C18.

Please include the formula you use to get the answers.

Thanks,

mark Letter grade Grade Description OF Fail Earned Mar Letter Grade Grade Description 50 D Barely pass Student1 90 55 D+ Pass Student2 67 60 C Credit Student3 76 65 C+ Good Credit Student4 89 70 B Good Student5 68 75 B+ Very Good Student6 98 80 A Excellent Student7 86 90 A+ Super Students 55 Student9 77 Use a vlookup function to calculate the letter grades from Student10 55 D4 to D18, based on the marks earned in C4 down to C18. Student11 66 Also use a vlookup function to calculate the Grade Student12 78 Description from E4 to E18, based on the marks earned in Student13 79 C4 down to C18. Student14 77 Student15 88