title: can i use index match to do wildcards of multiple text in a string
body: <p>i have seen a few discussions about using wildcards in excel but it seems to cover partial text as a single word: <a href="https://stackoverflow.com/questions/15566316/finding-partial-text-in-range-return-an-index">Finding partial text in range, return an index</a></p>
  
  <p>i want to be able to Index and MATCH by finding a word in string for example</p>
  
  <p>D4: "bob jim fred gary"</p>
  
  <p>=INDEX(D7:D10,MATCH("<em>"&amp;D4&amp;"</em>",C7:C10,0))
  (please note i have also tried(D4&amp;"*") and other variations of this)</p>
  
  <p>C9: fred D: yay</p>
  
  <p>This doesnt seem to work using range of wildcard options?</p>
  
  <p>Is there a way to match a segment of text in a string to do INDEX MATCH or produce data from a partial text match that isnt a full string?</p>
  
  <p>thank you for your expertise!</p>