Excel Is Fun

Excel Magic Trick 1348

DESCRIPTION See how to look up multiple items, retrieve the number associated with the items and add the array of numbers. Examples of SUM Many VLOOKUPs: (00:10) Introduction (01:00) Exact Math Lookup for Adding Multiple [Read More >>>]

Dueling Excel

Dueling Excel 149

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with [Read More >>>]

Dueling Excel

Dueling Excel 141

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1293

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) with a single cell lookup array formula that uses the LOOKUP and SUMPRODUCT functions and points to a proper data set. WORKBOOKS

Dueling Excel

Dueling Excel 137

DESCRIPTION Start and End Date, What is Total Pay Over Period Given Month Salary? See Mr Excel and excelisfun use two methods to calculate Start and End Date, What is Total Pay Over Period Given [Read More >>>]

Excel Is Fun

Excel Magic Trick 1278

Extract Colour From Description (Text String) Learn how to Extract Colour From Description (Text String) using LOOKUP & SEARCH functions and the Big Number 2^15 in an Array Formula. WORKBOOKS

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

Dueling Excel

Dueling Excel 116

Extract Individual Letters From Cell and do Lookup Adding, then… DESCRIPTION See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1234

DESCRIPTION VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range Learn how to use a helper column formula to lookup a discount rate in 36 different tables: (00:11) Introduction to problem we [Read More >>>]

Dueling Excel

Dueling Excel 100

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