Comparing two columns and finding matching names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excelissue - 12 Oct 2007 00:28 GMT

Please help...
I need to check one list of names against another list of names and to
determine if any of the names appear in both lists.

I.e.
Column A has 300 records
Column B has 100 records, I need to indicate if any record in Column B
matches any record in column A.

Reply to this Message

JW - 12 Oct 2007 00:53 GMT

On Oct 11, 7:28 pm, excelissue <excelis...@discussions.microsoft.com>
wrote:

> Please help...
> I need to check one list of names against another list of names and to
[quoted text clipped - 4 lines]
> Column B has 100 records, I need to indicate if any record in Column B
> matches any record in column A.

You can use VLOOKUP, MATCH, COUNTIF etc to do this.
This will return the value is it is found:
=VLOOKUP(B1,A:A,1,FALSE)

This will return the position in the lookup_array (A:A in this
example) if the value was found:
=MATCH(B1,A1:A,0)

This will count how many times the value in B1 occurs in column A:
=COUNTIF(A:A,B1)

Reply to this Message