Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384

April 15, 2011 at 2:34 pm

Another Dueling Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1384, Mike and Bill revisit the Invoicing question from Episode #1379: “Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?”. Using the set up from Episode #1379, today’s Duel focuses on adding Dynamic Validation and Dynamic VLOOKUP using OFFSET or INDEX. Follow along with Episode #1384 – Duel #75! – and let Mike and Bill show us how it’s done!

"Slaying Excel Dragons" by Mike Girvin and Bill Jelen"Dueling Excel Podcast #74…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]


"Microsoft Excel 2010: In Depth" by Bill JelenExcel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.


Entry filed under: Excel 2007, Excel 2010, Excel 2010 In Depth, Learn Excel from MrExcel, Mike Girvin and Bill Jelen, MrExcel Podcast, MrExcel Products. Tags: , , , , , , , , , , , , , , , , , .

MrExcel will be *LIVE* in South Bend, Indiana on May 3, 2011 Learn Excel – UDF in a Personal Macro Workbook? Podcast #1385

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: