title: Excel match(less than) function behaves inconsistently
body: <p>When I put a date at the first date location, I wish match(less than) function will return me the location of the rightmost match date on the same row.  (I understand it will not be recommended to put the search date on the same row)</p>
  
  <p>For row 3:3, it does what I want.  I get location 10.
  But for row 4:4, it returned me my search date location instead of the date in the date array.
  The only difference between the two rows is the search date cell on 4:4 is beyond column G.</p>
  
  <p>I could not explain why.  I wish I just miss some known fact.  I hope/expect Excel behaves consistently!  Thanks for any advice.</p>
  
  <p><img src="https://i.stack.imgur.com/x4Z51.gif" alt="Excel Match issue explanation"></p>