VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range
Learn how to use a helper column formula to lookup a discount rate in 36 different tables:
(00:11) Introduction to problem we want to solve and look back to Excel Magic Trick 1231 & 1232
(00:47) Create “Smart” Titles for each of the 36 tables.
(01:27) Helper Column Solution with SEARCH function and a Function Argument Array Operation, LOOKUP function, Big Number 2^15 for lookup value, and LOOKUP result joined to Product Name.
(06:30) VLOOKUP with Joined (Concatenated) lookup_value.