Dueling Excel

Dueling Excel 63

February 10, 2016 0

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

Dueling Excel

Dueling Excel 044

October 7, 2015 0

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

Dueling Excel

Dueling Excel 042

September 23, 2015 0

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

Dueling Excel

Dueling Excel 041

September 16, 2015 0

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. […]

Dueling Excel

Dueling Excel 040

September 9, 2015 0

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) […]

Dueling Excel

Dueling Excel 032

July 15, 2015 0

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

Excel Magic Trick 1094

February 1, 2015 0

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

January 12, 2015 0

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

Dueling Excel

Dueling Excel 001

January 2, 2015 0

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