Forum Discussion
IF-Then to compare participation list and include department info
Could someone support me with the following task? Sheet 1 has an overview of participants' names (Column A) Sheet 2 has an overview of all names in the organization (Column A) and their departme...
=VLOOKUP(A3,$E$3:$F$27,2,FALSE)=INDEX($F$3:$F$27,MATCH(A3,$E$3:$E$27,0))You can try INDEX and MATCH or VLOOKUP instead of a nested IF THEN formula. If you work with Office 365 or Excel 2021 you can apply XLOOKUP as well.
The INDEX and MATCH formula is in cell C3 in this example.