title: Is there a formula to find a specific number within a cell?
body: <p>I'm trying to find a specific identification number within a cell. The problem is that each cell containing such number has others too separated by a semi colon...
  I want to have the same results as if using lookup (not sure if it's possible). 
  The end result is to have the cost associated to each id number, that in turns is related to a specific order. <a href="https://i.stack.imgur.com/OWLEP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OWLEP.png" alt="Cell 4A contains the info I&#39;m looking for"></a>
   Thank you!</p>