Hello all. I have been struggling to get an Excel workbook formatted the way I need. So essentially what I am trying to do is have excel sheet quizzes for a student I'm tutoring. Column A will have questions. Column B will be where the student types answers (free form, mostly one word answers). Column C will grade each answer as "Pass" or "Fail". The answer key will be in Column A of Sheet2.

So my goal is to have the cell in the grading column (C) be blank if the reference answer cell in Column B is blank, say "Pass" if the reference cell contains the same answer as the corresponding answer key cell (i.e. Sheet1!B1=Sheet2!A1), and say "Fail" if it contains any other wrong answer. After consulting my local IT department they said the following formula should do what I want:

=IF(ISBLANK(B1),"",IF(B1=Sheet2!A1,"Pass","Fail")

While the first part works fine and the cell stays blank if the answer cell is blank, it says "Fail" even when the correct answer is typed.

Any ideas of where we went wrong?

Thanks in advance,
CJB