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