Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Welcome to Superuser. Can you show some example? – Siva Charan Mar 16 '12 at 6:34

Lets say column A is the list of employees doing function 1, and column B is the function 2 list.

Put this in the first position of column C and copy down the list:


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.

Then it is just a case of scanning the column C to see if there are any matches.

share|improve this answer
To make this a bit more efficient, this data can be put into a list (ctrl + a, ctrl + l), then use the filter options for column C to list only matches. – Michael H Sep 15 '13 at 5:37

For a single-cell solution, assuming data in rows 2 to 100 (adjust as required) try


returns TRUE if there are any matches, otherwise FALSE.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .