Nov 30 2021 05:57 AM
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.
Nov 30 2021 06:06 AM
=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?