Ask a question STEMPEKA - Last answered on Apr 16, 2013 at 06:33 PM by JeffS79

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!!!
plus moins
user 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)
Was this answer helpful?  
plus moins
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.
tarun- Jan 17, 2013 at 07:39 AM
its working only for MS office 2007
not in 2010
JeffS79- Apr 16, 2013 at 06:33 PM
This worked great as a very fast audit of 2 rows of text. Just type in the formula and filter by "false" to find the discrepancies. Amazing tip!
plus moins
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.
igor- Jul 1, 2010 at 01:40 PM
Dragging it was the key! Thank you
yaykarin- Aug 17, 2010 at 05:35 PM
Yes! I have tried SO many different "solutions" this finally did it. I had a long column A, a short column B and was able to remove any appearing in A that also appeared in B. So simple and yet so complicated. Thanks!
plus moins
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 :
I hope this helps

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!