Excel Magic Trick 1231

DESCRIPTION

VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?
Learn how to:
(00:12) Introduction to problem we want to solve.
(01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild card (zero or more characters)
(06:21) OFFSET Function Solution, with VLOOKUP and MATCH functions and the asterisk wild card (zero or more characters)
(09:45) Check is the results for two columns are equivalent using a logical formula and the COUNTIFS function with FALSE Criteria.
(10:25) INDIRECT function Solution, with VLOOKUP and Defined Names

Lookup to many tables. How to lookup to multiple tables. VLOOKUP with Multiple Tables.

WORKBOOKS




Be the first to comment

Leave a Reply