For example,
There are 3 students, with different scores from each unit.
I want the unit with the value 5 or lower score to show in the column "Student needs to focus on" without me having to look through the table. The first value that is 5 or lower starting from the left should be the point of reference of the column name, completely disregarding other columns on the right that meet the same requirement.
If my explanation is confusing (because it is confusing to me haha), please take a look at the table which is my desired outcome. The bolded part is what I want excel to calculate and output.

[Example of desired outcome](https://i.stack.imgur.com/XH96W.png)