### Excel Magic Trick 1314

August 17, 2017

DESCRIPTION See Excel Formula To Create Sorted Unique List On Mixed Data: (00:08) Problem set up (01:26) Essential logical behind Sorting Formula (04:38) Unique Count Formula For Mixed Data (08:27) Formula to Extract a Sorted […]

### Excel Magic Trick 1290

April 24, 2017

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database […]

### Excel Magic Trick 1287

April 13, 2017

DESCRIPTION SWITCH Function: How to Lookup Formulas, References, or Anything Else Learn how to: (00:11) Intro to Exact Match lookup SWITCH Function, including a default value. SWITCH in a New Excel 2016 function. (01:13) SWITCH […]

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

November 2, 2015

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

### Highline Excel 2013 Class Video 18

February 17, 2015

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your […]