Excel Magic Trick 1484

LOOKUP & Sorted Helper Column: Lookup 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 sort the lookup table by Effective Date within Product Column, then create a Helper Column (Key Column) as the first column in the lookup table and then use the & VLOOKUP & LOOKUP functions. Thanks to Enny Kraft at YouTube for this trick!


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

Be the first to comment

Leave a Reply