title: Trying to find the latest date prior to a specific date for a specific location
body: <p>I have looked thru multiple forums but have not found what I am trying to do. Any help is appreciated. </p>
  
  <p>I have a table with locations in the first column and truck delivery dates per location off to the right. </p>
  
  <p>What I am trying to do is look for the latest delivery date prior to a specific date for a specific location. MAX formula works great to find the date but I have a trouble finding based on location number lookup.  </p>
  
  <p>In the example below, I'm looking for the latest date prior to 7/20/2020 for location 110. Correct date is 7/8/2020.</p>
  
  <p><img src="https://i.stack.imgur.com/VfjFS.png" alt="Truck arrival date by location"></p>
  
  <p>MAX formula I can specify row 3 but I need to be able to look up multiple location and have not found a way lookup. </p>