https://bonbonsguide.com/wp/blog/2018/04/excel-magic-trick-1487-index-match-maxifs-lookup-correct-price-based-on-effective-date/
Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date