Dashboard Formulas Blueprints Dashboard

45+ lookup and advanced formulas templates that will pull almost any answer from your Excel Tables

Module 1 – Pulling out a single value

How to pull out a Text that Begins with/Ends with/ Contains… inc .xls 10:00
How to pull out Two Index Columns and other Advanced LOOKUP Formulas inc .xls 10:00
How to pull out the Max/Min Number, Newest/Oldest Date, A/Z Text inc .xls 10:00
How to pull out a Text Case-Sensitive inc .xls 10:00
How to pull out the Exact or Lower Approximate Text/Number/Date inc .xls 10:00
How to pull out the Exact or Lower/Greater Approximate Text/Number/Date inc .xls 10:00
How to pull out an exact Number/Date/Text inc .xls 10:00

Module 2 – Pulling out arrays

Module 3 – Pulling out the summary of a category