### Dueling Excel 131

March 1, 2017

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 […]

### Excel Magic Trick 1274

February 27, 2017

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 […]

### Highline Excel 2013 Class Video 23

February 17, 2017

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 […]

### Excel Magic Trick 1269

February 9, 2017

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 […]

### Excel Magic Trick 1268

February 6, 2017

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 […]

### Highline Excel 2016 Class 04

January 24, 2017

WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Tableā¦ DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example […]

### Excel Magic Trick 1260

January 9, 2017

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) […]

### Excel Magic Trick 1259

January 5, 2017

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 […]

### Excel Magic Trick 1253

December 5, 2016

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 […]

### Excel Magic Trick 1249

November 21, 2016

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 […]