title: How to query results that don't contain the #N/A error in Google Sheets
body: <p>I am trying to query results that don't contain <code>#N/A</code> results from another sheet in the same Google Sheets WorkSheet.</p>
  
  <p>I have tried this formula but it won't work</p>
  
  <pre><code>=QUERY('Table 1'!A2:G500, "Select F Where G &lt;&gt; '#N/A'")
  </code></pre>
  
  <p>Tried several other ways but still in vain. </p>
  
  <p>I need to select Column F where column G does not contain #N/A.</p>
  
  <p>Please help if you might know how to go about this.</p>