Excel Index Match with text string
<p><a href="http://i.stack.imgur.com/yLW91.png" rel="nofollow">enter image description here</a>I am trying to write a formula that will allow me to return a value based on it being matched with a short text string that is contained in a longer text string. Please see below. I would like the "Unit Time" column in the second table to retrieve that corresponding value from the first table by matching the shorter text string in the product column of the first table in the longer product name in the second table. Any thoughts would be appreciated.</p>

<p>Thanks</p>

<p><a href="http://i.stack.imgur.com/K3OxP.png" rel="nofollow">excel</a></p>