Рет қаралды 50,494
Download Excel Start File: excelisfun.net/files/EMT1230-...
excelisfun.net/files/EMT1230-...
Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?
Download File: excelisfun.net/
Learn how to:
1. (00:12) Introduction to problem we want to solve.
2. (01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild card (zero or more characters)
3. (06:21) OFFSET Function Solution, with VLOOKUP and MATCH functions and the asterisk wild card (zero or more characters)
4. (09:45) Check is the results for two columns are equivalent using a logical formula and the COUNTIFS function with FALSE Criteria.
5. (10:25) INDIRECT function Solution, with VLOOKUP and Defined Names
Lookup to many tables. How to lookup to multiple tables. VLOOKUP with Multiple Tables.