Excel Is Fun

Excel Magic Trick 1391

DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 11

DESCRIPTION In this video learn about: (00:12) Introduction (00:51) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice. (09:43) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone’s Phone Number. Horizontal Lookup [Read More >>>]

Excel Is Fun

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

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 1286

DESCRIPTION Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) Learn all about the new Excel 2016 IFS Function for situations where you have three or more items to put in [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 1231

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

Dueling Excel

Dueling Excel 97

Determine Quarter For column of Dates: CHOOSE or CEILING function? DESCRIPTION See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See [Read More >>>]

Tricks & Tips

Display Day Name From A Date

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]

Excel Is Fun

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