Comparing Lists

  • Thread starter Thread starter Jazming
  • Start date Start date
J

Jazming

I have 2 lists column A & Column B. They both contain text of company names.
I want to extract all the co's with similar names and place them in column
c. Please help!!
 
column c:
enter in C2:
=if(iserror(vlookup($A2,$B:$B,1,false)),"",$A2)
then copy the formula down in column C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple List Analysis 0
XL2000 CF and Comparing Lists 5
lookup functions and text comparisons 1
Sum values from a vlookup 2
Comparing two columns and returning value from another column 1
index and match on 2 criteria 5
Excel Comparing two columns 1
XL2000, CF and List Comparisons 3

Back
Top