Dueling Excel

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

Dueling Excel

Dueling Excel 040

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

Dueling Excel

Dueling Excel 032

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

Excel Is Fun

Highline Excel 2013 Class Video 28

DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your Data Validation. 3. Error Message with “Stop”. 4. Circle [Read More >>>]

Excel Is Fun

Excel Magic Trick 1094

DESCRIPTION See how to lookup all A8 cell references from across many sheets using a wildcards, incomplete sheet names and the INDIRECT function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1088

DESCRIPTION Show All B7 values From Across Sheets that are Named 01, 02, 03, …10, 11… using the functions: INDIRECT, TEXT and ROWS WORKBOOKS