### Excel Magic Trick 1314

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 [Read More >>>]

### Excel Magic Trick 1290

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 [Read More >>>]

### Excel Magic Trick 1287

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 [Read More >>>]

### Excel Magic Trick 1174

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 [Read More >>>]

### Highline Excel 2013 Class Video 23

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 flat commission rate when there [Read More >>>]

### Highline Excel 2013 Class Video 18

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 [Read More >>>]