Excel function

%3CLINGO-SUB%20id%3D%22lingo-sub-3018264%22%20slang%3D%22en-US%22%3EExcel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018264%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EI%20need%20a%20simple%20formula%20that%20compares%20the%20information%20in%20the%20two%20excel%20tabs%20and%20returns%20participant's%20colour%20from%20sheet%202%2C%20if%20the%20participant's%20name%20matches.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20is%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3018264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3018324%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1233566%22%20target%3D%22_blank%22%3E%40Mooya1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(A2%26amp%3BB2%2CCHOOSE(%7B1%2C2%7D%2CSheet2!%24A%242%3A%24A%246%26amp%3BSheet2!%24B%242%3A%24B%246%2CSheet2!%24C%242%3A%24C%246)%2C2%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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?