Matching Column Data
 

I have a fairly simple Excel problem (I believe) but I cannot seem to
solve it.
Column A: A list of 65,000+ companies, formatted as text, in CAPS
Column B: A list of 1200 companies, formatted as text, in CAPS

I would like to look at each company in Column B, see if its name is
in any row (partial match if possible) in column A. If there is a
match, let me know in column C (Where I am putting my function) via a
row #, # of matches, anything. I just need to know which companies in
column B are found in A.

I have tried a LOOKUP function, but for some reason it will only tell
me if there is a match if the exact rows match (I did make column A
all of my search range) or it will put names of companies in column C
that are not in A).

Matching Column Data
 

You could use a looping macro for each col B and test to see if in col A.
Then, either color it or delete it or ???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bengt" wrote in message
...
I have a fairly simple Excel problem (I believe) but I cannot seem to
solve it.
Column A: A list of 65,000+ companies, formatted as text, in CAPS
Column B: A list of 1200 companies, formatted as text, in CAPS

I would like to look at each company in Column B, see if its name is
in any row (partial match if possible) in column A. If there is a
match, let me know in column C (Where I am putting my function) via a
row #, # of matches, anything. I just need to know which companies in
column B are found in A.

I have tried a LOOKUP function, but for some reason it will only tell
me if there is a match if the exact rows match (I did make column A
all of my search range) or it will put names of companies in column C
that are not in A).