Not sure if I understand the question correctly but did you try something like this
This should check if SupID equals username in any row.
Then if any row returns TRUE, MAX will cause it to repeat for all rows.
Many thanks. You are a life savor.