title: Turn a cell into a hyperlink if there is a URL
body: <p>I have a sheet in excel that contains names and alongside the name for "some" of the names is a URL.</p>
  
  <p>The name is then used in another sheet and may follow on into other cells.</p>
  
  <p>Basically, it is a pool tournament and winners go through to later rounds in the tournament and what I want to happen is that, if there is a URL in the sheet to turn the instances of their name following on into hyperlinks.</p>
  
  <p>I am aware of the vlookup, HYPERLINK() and if's etc but linking them all together and it actually working is hurting my brain!</p>
  
  <p>The cell D68 currently contains:</p>
  
  <p><code>=IF(E4&lt;&gt;"",IF(E4&lt;F4,G4,D4),L4&amp;" - "&amp;M4)</code></p>
  
  <p><a href="http://i.stack.imgur.com/C2mp6.png" rel="nofollow">Sheet One</a></p>
  
  <p><a href="http://i.stack.imgur.com/eG2fj.png" rel="nofollow">Sheet Two - Second instance of the name</a></p>