title: Verifying multiple text sub-strings in numerous cells
body: <p>First time poster and new to VB but fairly fluent in Excel.
  I have a question similar to what's asked in this post (<a href="https://stackoverflow.com/questions/12395971/excel-how-can-i-identify-rows-containing-text-keywords-taken-from-a-list-of-key">excel: how can I identify rows containing text keywords taken from a list of keywords</a>) however I need to read strings of text in both columns and compare them. If I find 2 or more matching strings I want the value from my second column to be used for my output in my 3rd column.</p>
  
  <p>So in column A I have:
  7-zip beta
  Adobe Acrobat
  ActivePerl
  Apache Tomcat 7.9.0
  Excel Chart Utilities
  Microsoft Office Ultimate 2007</p>
  
  <p>In column B I have:
  7zip
  Adobe Acrobat Reader
  Apache Tomcat 
  Excel Chart </p>
  
  <p>In column C I want the official software entry from column B if 2 or more text sub-string match.</p>
  
  <p>Problems: my column A still contains the version number for the software I want to compare and is not necessary entered into my spreadsheet the same way as my official software list should be (column B). My column B contains only 600 rows while my column A contains close to 8000 rows. In addition, all duplicates in the respective columns have already been removed. </p>
  
  <p>Any help would greatly be appreciated.</p>