Excel Is Fun

Excel Magic Trick 1490

DESCRIPTION In this video learn how to create a DAX Calculated Column for Exact Match Lookup and Approximate Match Lookup. See how to combine the two lookups in a formula to lookup the correct Volume [Read More >>>]

Excel Is Fun

Excel Magic Trick 1489

DESCRIPTION In this video learn how to create a single Excel formula that will lookup a product price and lookup the volume / quantity discount and deliver the correct discounted Product Price. See how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1488

DESCRIPTION Vote For Favourite Formula to Lookup Correct Price Based on Effective Date WORKBOOKS

Excel Is Fun

Excel Magic Trick 1487

DESCRIPTION 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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1486

DESCRIPTION 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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1485

DESCRIPTION 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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1484

DESCRIPTION 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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1483

DESCRIPTION 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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1482

DESCRIPTION In this video learn how to Count with an OR Logical Test based on Three Columns. See a Pharmacy Data Set with Patient Data with the goal of counting how many patients are eligible [Read More >>>]

Excel Is Fun

Excel Magic Trick 1481

DESCRIPTION In this video learn how to how to perform lookup from multiple tables. Learn two methods: 1) VLOOKUP and SWITCH Function or 2) VLOOKUP and INDIRECT Function with Defined Names. (00:01) Introduction (01:30) VLOOKUP [Read More >>>]