Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table




About this tutorial:

Video duration: 00:14:45
Download Excel Files:

Start File:

Finish File:

Home page:

Download File:
Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database can update and change the size of the lookup tables. This amazing suggestion and OFFSET formula comes from Craig.

1. (00:12) Problem Description
2….

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads