VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function
Learn how to do a VLOOKUP to 36 Different Dynamic Tables (will have records added and removed over time) using the Excel Table Feature & INDIRECT Function:
(00:11) Introduction to problem we want to solve and look back to Excel Magic Trick 1231
(00:54) How to create an Excel Table and Name the table with keyboard shortcuts.
(02:43) VLOOKUP and INDIRECT Function to create formula to lookup discount rates from 36 different tables.