Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function HD

Download File: http://people.highline.edu/mgirvin/excelisfun.htm 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: 1. (00:11) Introduction to problem we want to solve and look back to Excel Magic Trick 1231 2. (00:54) How to create an Excel Table and Name the table with keyboard shortcuts. 3. (02:43) VLOOKUP and INDIRECT Function to create formula to lookup discount rates from 36 different tables.