Excel function

Hi 🙂

I need a simple formula that compares the information in the two excel tabs and returns participant's colour from sheet 2, if the participant's name matches.

File is attached.

Thanks in advance.