https://bonbonsguide.com/wp/blog/2018/04/excel-magic-trick-1483-lookup-array-formula-lookup-correct-price-based-on-effective-date/
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date