title: Adding a clause into a vlookup for specific condition
body: <p>I have the current VLOOKUP formula:</p>
  
  <pre><code>=VLOOKUP($C$5,Raw!$A$2:$FJ1000,115,FALSE)
  </code></pre>
  
  <p>This works fine, collecting and displaying the relevant data. But if the VLOOKUP corresponds to a blank cell, a ‘0’ is displayed. Can I modify this formula so that instead of ‘0’ it displays "New"?</p>