IF-Then to compare participation list and include department info

[MkThu]

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 departments (Column B)

I want to import the department info from Sheet 2 into Sheet 1 so that they match the names - at the end, I want an overview in sheet 1 of the names of participants and the department they are in.

[#2]

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