title: Looking string inside cell Text (VB)
body: <p>I'm looping row inside sheet and I want to find string inside some text:</p>
  
  <pre><code>lr = ws.Cells(Rows.Count, "A").End(xlUp).Row
  lrk = wsK.Cells(Rows.Count, "A").End(xlUp).Row
  
  For i = 2 To lr --looping list
    look_name = UCase(ws.Range("E" &amp; i).Value)
  
      For j = 2 To lrk --loop patern value
      look_text = UCase(wsK.Range("A" &amp; j).Value)
  
          If look_name Like "*look_text*" Then --if found
              ws.Range("AB" &amp; i) = wsK.Range("B" &amp; j).Value --to do
              Exit For
          End If
  
      Next j
  Next i
  </code></pre>
  
  <p>I think something wrong I did with <code>"*look_text*"</code></p>
  
  <p>If <code>look_name = "New city"</code> and <code>look_text = "city"</code>, it's not going into IF.</p>