title: Index Match to return MAX Date with multiple criteria
body: <p>apologies for this, I'm assuming this is simple but a few hours of SO googling hasn't helped </p>
  
  <p>Enough whining from me:</p>
  
  <p>Consider the following dataset:</p>
  
  <pre><code>ID, Date, Review, Review    Status
  1   01/02/18, "Cool",       Positive
  1   01/03/18, "Awesome", "  Positive
  1   01/01/18, "Cumbersome", Negative
  1   01/02/18, "Rubbish!", " Negative
  </code></pre>
  
  <p>I'm currently using an array type index match to get the latest review based on a few conditions </p>
  
  <p>I have two columns one which says positive, one negative.</p>
  
  <p>in each of the column I would like to return the latest positive review but I'm unsure how to get the max date within the below formula:</p>
  
  <pre><code>{=index(C2:C4, MATCH(1,(1 = A2:A4)*("Positive" = D2:D4)*(maxdatehere = B2:B4),0))}
  </code></pre>
  
  <p>The data I have is around 7k rows and is Google Review Data and pretty much matches the example above. </p>
  
  <p>I'd rather not use VBA as I've never really used it before (but will do so grudgingly) </p>
  
  <p>as this is excel I've not created a google demo sheet, but happy to do so for ease of the experts and for others to benfit if they find there way here one day. </p>