Look up in the range

Hello.

I am trying to create a formula, that would look up the name of the column with the last value OK as per example below. Could you please help with the syntax?

Max#1 Max#2 Max#3 Max#4 Expected Result
NOT OK OK OK OK Max#4
NOT OK OK NOT OK NOT OK Max#2
NOT OK OK OK NOT OK Max#3

Thank you in advance.
Alisa

Try this:

=LOOKUP(2,1/($A2:$D2="OK"),$A$1:$D$1)

Change the ranges to suit.

No problem.