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

### Excel Magic Trick 1242

October 27, 2016

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and […]

### Excel Magic Trick 1235

October 3, 2016

DESCRIPTION 2-Way Lookup For Currency Conversion: Donâ€™t Use IF, Use INDEX or VLOOKUP Learn how to do a two way lookup to retrieve the conversion rate for currencies: (00:11) Two-Way Lookup for Currency Conversion Problem […]

### Dueling Excel 105

September 21, 2016

Count Between Words DESCRIPTION See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words WORKBOOKS

### Excel Magic Trick 1231

September 19, 2016

DESCRIPTION VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? Learn how to: (00:12) Introduction to problem we want to solve. (01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild […]

### Dueling Excel 103

September 16, 2016

Find Missing Numbers In A Series DESCRIPTION See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use the functions IF, ISNA, VLOOKUP, ROW, and SMALL […]

### Dueling Excel 100

September 7, 2016

Two Way Lookup Formula and Conditional Formatting! DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions 2. Excelisfun […]

### Excel Magic Trick 1226

September 1, 2016

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

### Dueling Excel 98

August 31, 2016

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]