# Excel – How to compare data in 2 columns in Excel and then in one cell, determine if there are similar data in both columns

microsoft excel

I have 2 columns in Excel: the first contains a list of employee names who perform function A, and the second contains a list of employee names who perform function B.

What I want is to identify, in one cell, if there is one employee whose name appears in both the first and second columns. It does not have to show which name(s) appears in both columns, it just needs to identify IF there are any names that appear in both columns.

=IF(ISERROR(MATCH(A1,$B$1:$B$999,0)),"","Match")

Any entries that are in column A that have a match in column B will show "Match". Modify $B$999 to match the length of your column.