title: How to make FILTER formula ignore blank cells in Google Sheets
body: <p>I am trying to build a database of all the technology resources we have in our company. I would like to have a search table on another tab where a user can narrow down what they are looking for using a few drop down menus. For example, they could choose &quot;Laptop&quot; from  the &quot;Equipment&quot; drop down, and the list would populate with all the Laptops in the company. They could then select &quot;Las Vegas&quot; from the &quot;Office&quot; drop down, and it would populate with all the laptops in the Vegas office.</p>
  <p>I have been using the FILTER formula with various forms of logic. When I use AND, it's considering the blank cells from the unused drop downs, so it returns #N/A since it can't find any rows matching the selections plus a lot of blank cells. When I use OR, I end up getting nearly everything from the database.</p>
  <p>I've tried using both AND and OR together, incorporating IF statements with &lt;&gt;&quot;&quot;, as well as various variations incorporating all three of them, but nothing has worked. I'm at a bit of a loss. Is there any way to get FILTER to ignore the cells that are blank?</p>
  <p>Link to a sample spreadsheet is <a href="https://docs.google.com/spreadsheets/d/1H1TQFw02ztMHe6mbvla-evMtyrCLDuHU_b2G654e_RM/edit?usp=sharing" rel="nofollow noreferrer">here</a>.</p>