title: Excel Formula - Partial Match and show value
body: <p>I have been trying with COUNTIF, LOOKUP and MATCH and cannot seem to work out this formula and would really appreciate the help !</p>
  
  <p>There is a list of POSTCODES (Column A) in Sheet 1 with a list of PARTIAL POSTCODES (Column A) in Sheet 2, with accompanying codes - CODE 1 (Column B) and CODE 2 (Column C).  What i am looking for is a formula that will :</p>
  
  <ol>
  <li>Take the POSTCODE from Sheet 1</li>
  <li>Lookup and do a partial match in POSTCODE in Sheet 2</li>
  <li>If match then take CODE 1 and CODE 2 from Sheet 2 and enter it in Sheet 1</li>
  </ol>
  
  <p>Example of what i am looking for : <a href="http://www.theukwebspace.co.uk/example.png" rel="nofollow">http://www.theukwebspace.co.uk/example.png</a></p>