title: Dynamically Finding values grouped by subcategories
body: <p>I am looking to see if there is an excel formula that allows me to do the following:</p>
  
  <p>I have a company name and under each company name is the year not necessarily in order</p>
  
  <p><a href="https://i.stack.imgur.com/n36vz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n36vz.png" alt="example of what I am looking to achieve"></a></p>
  
  <p>I have tried many ways of thinking about it, but I can't overcome how to search on the same column with two criteria without just selecting the same 2019 number. Any help would be appreciated!!</p>
  
  <p>Thank You!</p>