Send the following on WhatsApp
Continue to ChatExcel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date https://bonbonsguide.com/wp/blog/2018/04/excel-magic-trick-1485-sumifs-maxifs-functions-lookup-correct-price-based-on-effective-date/