Forum Discussion
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 i...
=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?