### Excel Magic Trick 1233

DESCRIPTION VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function Learn how to do a VLOOKUP to 36 Different Dynamic Tables (will have records added and removed over time) using the Excel Table [Read More >>>]

### 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 103

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

### Dueling Excel 69

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

WORKBOOKS

### Dueling Excel 001

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection [Read More >>>]

### Dueling Excel 63

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

### Dueling Excel 044

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

### Dueling Excel 042

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

### Dueling Excel 041

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