title: Partial match Excel
body: <p>I have Table A which contains only strings, or strings+numbers, in general the list is very inconsistent. I also have Table B which contains a list of the names I have to retrieve from Table A where there is a match or partial match. My issue is that sometimes my formula doesn't work.</p>
  
  <p>As you can see in Column C the below formula works for all except for rows 5 and 8 because I want to retrieve "toro res" which is in my list (table B) and instead I have 0.</p>
  
  <p><a href="https://i.stack.imgur.com/vB7pP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vB7pP.jpg" alt="enter image description here"></a></p>