title: Partial text INDEX/MATCH excel 2007
body: <p>So I have a column where single cells have numerous data within  them. i.e. in A1 it says ABC;# DEF ;# GHI where ABC, DEF and GHI are all individual peices of data. </p>
  
  <p>I am creating a dropdown box where this data is needed, but if there is multiple letter combinations in a single cell the drop down box takes this as one single peice of data rather than 2 or 3. </p>
  
  <p>I want to create an INDEX/MATCH function which will find corresponding data to these letter combinations, also returning data where the the corresponding combination is in a cell with other combinations. i.e. dog ABC ;# DEF when i search DEF dog will be returned.</p>
  
  <p>I am assuming I can do this with a wildcard? Am I correct or is there alternative, better, methods? Plus if it is done via a wildcard how do I write the formula </p>