ExcelBanter - Comparing Lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comparing Lists (https://www.excelbanter.com/excel-worksheet-functions/193644-comparing-lists.html)

Jazming

Comparing Lists

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!!

Tieske[_2_]

Comparing Lists

column c:
enter in C2:
=if(iserror(vlookup($A2,$B:$B,1,false)),"",$A2)
then copy the formula down in column C

"Jazming" wrote in message
...
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!!

All times are GMT +1. The time now is 02:35 PM.