Building on yesterday's podcast, life becomes considerably more complexif you need to use VLOOKUP to look into a different workbook based on adate.
Episode 820will show you why INDIRECT won't work and takes a look at how to useHarlan Grove's PULL function. Download the function fromftp://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!
More...
08/08/08, 16:40:58
Episode 820 - PULL 
Mode Lineal
