Sheets AcademySheets Academy
Premium
Task #88

Olympiad scores

A homeroom teacher is copying school olympiad scores from the overall results sheet E2:G9 into her class list.

In C2:C9, pull in each student's score by participant ID. Students who didn't take the olympiad aren't in the results: instead of the #N/A error, they should get “absent”.

Task #88
Olympiad scores

A homeroom teacher is copying school olympiad scores from the overall results sheet E2:G9 into her class list.

In C2:C9, pull in each student's score by participant ID. Students who didn't take the olympiad aren't in the results: instead of the #N/A error, they should get “absent”.