### Create a Dynamic Data Validation List

When you create a Data Validation list in Excel it is locked to the range you select when you first create the list. There are couple of ways of making this list dynamic allowing your [Read More >>>]

### Excel Magic Trick 1448

DESCRIPTION See how to create Conditional Formatting for Truck Arrival Dates that shows Blue when truck in unloaded, green when it less than 2 days since arrival, yellow when it is 2 days since arrival [Read More >>>]

### Excel Magic Trick 1431

DESCRIPTION See how to: (00:10) Introduction (00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project (10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each [Read More >>>]

### Excel Magic Trick 1290

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database [Read More >>>]

### Dueling Excel 129

DESCRIPTION Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn: 1. OFFSET function to create dynamic [Read More >>>]

### Dueling Excel 123

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. [Read More >>>]

### Dueling Excel 112

Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a cell reference in a two way table and create a dynamic [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 75

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS

### Dueling Excel 006

DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS