View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Search for a text string

Hi,

I have 2 lists of companies.

I want to search for whether the companies on list 1 are on list 2.

For example, "Chrysler Holding LLC" on list 1, "Chrysler Holding" on list 2.
How can I search "Chrysler" from list 1 is on list 2 as well.

Thanks.