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

Dueling Excel

Dueling Excel 96

LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add [Read More >>>]

Dueling Excel

Dueling Excel 94

Lookup Data In Text String & Extract Data From Text String DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Lookup Data In Text String & Extract Data From Text String in order [Read More >>>]