Excel Magic Trick 1486

VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date


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 VLOOKUP and MAXIFS functions (also AGGREGATE Function) and a Helper Column (Key Column) in the Lookup Table.


Download “Excel Magic Trick 1481-1490” Excel-Magic-Trick-1481-1490.zip – Downloaded 198 times – 2 MB

Be the first to comment

Leave a Reply