Dueling Excel

Dueling Excel 131

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP [Read More >>>]

Excel Is Fun

Excel Magic Trick 1274

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 23

VLOOKUP and IFNA for Commissions DESCRIPTION Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1269

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot [Read More >>>]

Excel Is Fun

Excel Magic Trick 1268

DESCRIPTION Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables [Read More >>>]

Excel Is Fun

Excel Magic Trick 1260

DESCRIPTION VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table: (00:12) Problem setup. (00:49) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1259

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP [Read More >>>]

Excel Is Fun

Excel Magic Trick 1253

DESCRIPTION Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup [Read More >>>]

Excel Is Fun

Excel Magic Trick 1249

DESCRIPTION Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail **Note; The word “Database” is used loosely in this video. We use it just to mean we have a dynamic table [Read More >>>]

Dueling Excel

Dueling Excel 115

Plot Chart, Show Only Selected Employee Name Is Axis DESCRIPTION See Mr Excel and excelisfun use two methods to plot all the sales for all the employees, but show only the employee name of selected [Read More >>>]