Learn Excel Episode 890: Offset as TableArray

Posted in Companies, Podcasts on November 14, 2008

An alternative to Episode 889...If you need to match two sorted columns with a VLOOKUP, you can make the table array be dynamically calculated with the OFFSET function. Episode 890 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, VLOOKUP, Offset, formula