Excel: how to leave only rows in a table that are in another table?

Question

excel

There is a list of company people in one document. There is a list of people from the IT department in another. How to apply a filter to the first one so that only rows from the second remain?

Answer 1

Make an additional column in the first table with the formula "=VLOOKUP([@Name];Table2[Name];1;0)", and filter by this column (not equal to "#N/A"). "Name" - the name of the column with the names of people (both in the first and second tables they are named the same); "Table2" - the name of the second table (a list of people from the IT department).

Answer 2

There is a VLOOKUP() function that can pull up all matching employees from the second list (for example, if it matches, insert "1" into the adjacent cell), and then filter out non-empty cells and rejoice.