Re: IF-Then to compare participation list and include department info

MkThu 

=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.