Dueling Excel 141

Lookup 3 Items in 3 tables: VLOOKUP, LOOKUP, VBA, Array?

DESCRIPTION

See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the three values (the first two parts will answer the question quickly), but then Mr Excel and Excelisfun start to imagine other near impossible ways to solve this problem and in the process discuss some interesting items:
1. 3 VLOOKUP functions and 3 lookup tables
2. 3 LOOKUP functions and 3 lookup tables
3. Can it be done with an array formula?
4. Array formula, but only 1 lookup table, Discuss function argument array operation
5. Can functions have more than 1 array in them?
6. VBA?
7. Some functions like SUMIFS and LARGE can have a “sort of” two arrays in them

WORKBOOKS

Download “Dueling-Excel-141-150.zip” Dueling-Excel-141-150.zip – Downloaded 94 times – 185 KB




Be the first to comment

Leave a Reply