Dueling Excel

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

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

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