Excel Is Fun

Excel Magic Trick 1231

September 19, 2016 0

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

Dueling Excel 103

September 16, 2016 0

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

Dueling Excel 69

March 16, 2016 0

Count Saturdays DESCRIPTION See Mr Excel and excelisfun create formulas to count Saturdays from a start date and end date. See the functions NETWORKDAYS.INTL, INDIRECT, ROW, WEEKDAY and SUMPRODUCT. See Mike Total mess up the […]

Dueling Excel

Dueling Excel 63

February 10, 2016 0

2 Criteria Lookup and Multiple Table Lookup From Different Sheets DESCRIPTION See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that: 1. Uses functions […]

Dueling Excel

Dueling Excel 044

October 7, 2015 0

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and […]

Dueling Excel

Dueling Excel 042

September 23, 2015 0

Lookup Picture In Excel Formula or VBA? DESCRIPTION See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See many […]

Dueling Excel

Dueling Excel 041

September 16, 2015 0

VBA or Formula Extract Prefix for VLOOKUP DESCRIPTION See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. […]

Dueling Excel

Dueling Excel 040

September 9, 2015 0

VLOOKUP to 3 Different Lookup Tables (3 table_arrays) DESCRIPTION See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks: 1) INDIRECT and CHOOSE 2) CHOOSE alone 3) […]

Dueling Excel

Dueling Excel 032

July 15, 2015 0

Three Methods for 2-Way Look DESCRIPTION See Mr Excel and excelisfun do two-way lookup three different ways: 1.INDEX and MATCH functions 2.VLOOKUP and MATCH functions 3.INDIRECT function and the Intersection Operator WORKBOOKS