Today’s question comes from Ron and he would like to know, “when would I use OFFSET in conjunction with the VLOOKUP Function?” In Episode #1619, Bill “MrExcel” Jelen explains the use of OFFSET and VLOOKUP together as well as provides us a great example.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!