https://bonbonsguide.com/wp/blog/2018/04/excel-magic-trick-1486-vlookup-maxifs-key-lookup-correct-price-based-on-effective-date/
Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date