Episode 820 - PULL

Building on yesterday's podcast, life becomes considerably more complex if you need to use VLOOKUP to look into a different workbook based on a date. Episode 820 will show you why INDIRECT won't work and takes a look at how to use Harlan Grove's PULL function. Download the function from ftp://members.aol.com/hrlngrv/pull.zip

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!