https://bonbonsguide.com/wp/blog/2018/04/excel-magic-trick-1488-vote-for-favorite-formula-to-lookup-correct-price-based-on-effective-date/
Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date