Index / Match / Jump to next column if value already used

Hi!

I tried to search the forum for a result but without any luck for this particular case.

Please see attached spreadsheet. Is there any solution to bring in cell B10 "Daniel" instead "Pascal" (again)? The solution/adjustment should be a single formula (meaning no additional helper column, etc.).

Many thanks,
FixandFoxi