Comparing two columns of names in Excel

STEMPEKA - Updated on Jan 10, 2019 at 05:43 AM
 JeffS79 - Apr 16, 2013 at 06:33 PM

I have one excel sheet. column A has a list of names formated as follows:

Last name, First name

Column B has a much longer list o names in the same format.

Some of the names in column A exist in column B.

I am looking for a formula that will produce in column C the names that appear on both lists.

Thanks for your help!
System Configuration: Mac OS X Safari 525.27.1

4 replies


Use vlookup formula if you have same name in second column
=vlookup (select any one name in column A prefer first name, then select full range of column B. Then, 1, FALSE)