title: Google Drive Spreadsheets: Combining IF and VLOOKUP
body: <p>I'm trying to work out a formula for combining an <code>IF</code> statement and a <code>VLOOPUP</code>.</p>
  
  <p>Basically, I want the formula to return a value if a value was found through VLOOKUP, or to return something else if not found...</p>
  
  <p>I have experimented with </p>
  
  <pre><code>=IF(VLOOKUP(A1,$B$2:$B$31, 1, 0),"FOUND","NOT FOUND!")
  </code></pre>
  
  <p>... but this doesn't seem to work.</p>
  
  <p>Many thanks for any thoughts you might have...</p>