### 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 Magic Trick 1488

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

### 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 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 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 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 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 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 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 >>>]

### Excel Magic Trick 1480

DESCRIPTION In this video learn how to do a two-way lookup to get the correct Price based on Quantity Discount & Product Name. Learn how to use the VLOOKUP and MATCH Functions. WORKBOOKS