DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so [Read More >>>]
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 >>>]
DESCRIPTION Vote For Favourite Formula to Lookup Correct Price Based on Effective Date WORKBOOKS
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 >>>]
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 >>>]
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 >>>]
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
DESCRIPTION In this video learn the Basics of VLOOKUP to looks up a price based on a Bulk Quantity Discount. Also learn about the MATCH Function to automatically pick out the correct Column Number for [Read More >>>]
DESCRIPTION In this video learn about how to use Excel Tables, One-To-Many Relationships and the Data Model as a substitute for a VLOOKUP Function Helper Column for a Large Data Set. Discuss pros and cons. [Read More >>>]
DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. [Read More >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.