Excel function

Occasional Visitor

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.

1 Reply

@Mooya1 

=VLOOKUP(A2&B2,CHOOSE({1,2},Sheet2!$A$2:$A$6&Sheet2!$B$2:$B$6,Sheet2!$C$2:$C$6),2,0)

 

Is this what you are looking for?