Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching column data | Excel Discussion (Misc queries) | |||
Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
matching data from column b | Excel Worksheet Functions | |||
Matching data in one column to another | Excel Worksheet Functions |