Hi
I'm struggling to finalise a formula.
Students write various tests in the class. If they fail any they fail overall.
I have a table with list of students and test results.
I'm looking for a formula that checks against each students results and if there is a 'FAIL' the formula returns fail.
If they're all 'pass' then it shows a pass.
I tried a vlookup, but it only finds the students first test results. I want it to check against each test result.
See attached demo.
Any help is greatly appreciated!
Kind Regards
Alex
Bookmarks