Excel Magic Trick 1170

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.

Be the first to comment

Leave a Reply