title: Address lookup after filter
body: <p>I have a Google form and a spreadsheet that is supposed to process it. The spreadsheet needs to filter the responses by date and get their respective data after that.</p>
  
  <p>E.g. Consider:</p>
  
  <p><a href="https://i.stack.imgur.com/wKcFt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wKcFt.png" alt="example table"></a></p>
  
  <p>With the columns being A and B and the rows being 1-4.</p>
  
  <p>How do I filter it by month in ascending order followed by adding the amount next to it?</p>
  
  <p>So it would look something like:
  <a href="https://i.stack.imgur.com/PTZ5N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PTZ5N.png" alt="processed table"></a></p>
  
  <p>I understand how to filter by month in ascending order. It is done using <code>=SORT(FILTER(A:A, MONTH(A:A)=1))</code> (for Jan). But how do you get the data next to it? I have tried <code>=INDIRECT(ADDRESS(SORT(FILTER(A:A, MONTH(A:A)=1)), 2))</code> but there is no error and it is blank.</p>