mardi 16 novembre 2021

How do I return a true or false based on multiple criteria in Google sheets?

In my Google sheets workbook I have one tab (call it Classlist) that has rows with the student's last name, first name, email address, and a series of checkboxes for the quizzes in the course. The columns are the names of the quizzes. In another tab (call it Grades) I have the student's last name, first name, quiz taken, and pass/fail. What I'm trying to do is create a formula that will search Grades and if the particular student has passed a particular quiz it checks the checkbox in Classlist. So The last name, first name, quiz, and grade have to be right and it has to return a true or false in order to check the box. I've tried "IF/AND" formulas, VLookup, I even installed an add-on for Xlookup, but I can't get it to work. Any ideas?

Aucun commentaire:

Enregistrer un commentaire