title: Compare two excel datasets (worksheets) & add value
body: <p>i have to compare two worksheets and add values on Worksheet 1 if a match is success.</p>
  
  <p>Worksheet1 = Worksheet where i have to add values in Column B (the value is a string)
  Worksheet2 = List of Data which will be used for search in Worksheet1</p>
  
  <p>Worksheet1:</p>
  
  <p>Column A.........................Column B</p>
  
  <p>2016_ABC</p>
  
  <p>2016_XYZ</p>
  
  <p>2015_ABC</p>
  
  <p>2013_XYZ</p>
  
  <p>Worksheet2:</p>
  
  <p>Column A</p>
  
  <p>ABC</p>
  
  <p>XYZ</p>
  
  <p>DJH</p>
  
  <p>UIJ</p>
  
  <p>So, what i want is a formula or simple way (please not VBA, i already have a script in vba - but i have to keep it easy for customer) that compares
  Values in Worksheet2/Column A with Worksheet1/Column A.</p>
  
  <p>I cannot compare with an exact MATCH, i have to use something like "CONTAINS".</p>
  
  <p>If values in Worksheet2 Column A contains in Worksheet1 ColumnA  add in same Row Worksheet1 Column B a string like "Contain!"</p>
  
  <p>Thanks in advice. Have a nice day.</p>