VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions
See how to:
(00:09) Problem Setup
(01:40) COLUMNS Function with expandable range to get Sequential Numbers across the columns
(02:17) CHOOSE Function to look up different tables
(03:35) VLOOKUP with CHOOSE and COLUMNS to get different price from different lookup tables based on Column that formula sits in.