Comparing two columns of names in ExcelSolved/Closed

Question

Hello,

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

zia · Accepted Answer

Hey, 

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)

Thanks!

xlcomparator · Answer

Hi STEMPEKA,
I see that this thread status is "not resolved".
You will find here an other way to solve your problem without using macro or formula :
https://ccm.net/faq/5278-how-to-compare-two-workbooks-worksheets
I hope this helps
Marc

Ravindra · Answer

I have an Answer : 

It is possible that I can give you the formula you will get the details of the name which you have in column B

Ex : =vlookup(select column b,select the range the same you have in column A,1,0) hit the Enter and  drag the formula till the end.

Tamizh · Answer

Hi You can have a true or false formula as
=A2=B2. Then if same cell has the same data you will result it with True. If not the same will be False.

Comparing two columns of names in Excel

4 replies

Similar discussions

Subscribe To Our Newsletter!