title: Limiting row returns in table column search
body: <p>I am trying to look up some data from a table in Excel, using the following formula</p>
  <pre><code>=IF(Table_People[Polity]=lookup_PolityRuler, Table_People[Name],&quot;&quot;)
  </code></pre>
  <p>This does return only the rows that I want as a dynamic range. However, it also returns blank rows where the other data was (see below):</p>
  <p><a href="https://i.stack.imgur.com/u97DP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u97DP.png" alt="Blank Rows in Lookup" /></a></p>
  <p>How can I (/ is it possible to) get just the rows from the data using a formula such as this?</p>