Download Excel File: https://excelisfun.net/files/EMT1483-1487.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. In this video learn about how to use the INDEX, MATCH and MAXIFS functions in an Array Formula.

Related Videos:
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date
Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date
Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date

Vote for your favorite formula, here: https://forms.office.com/Pages/ResponsePage.aspx?id=AzbjXcO4-06rg5AtOyQeHEQGbPtdBrxLqFDLktGSNXBUNTZXWTZOWEtPVEg0TlZJUkJNQkpKMEtIRS4u