Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384
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!
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]
“Excel 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: 2010, accounting, Bill Jelen, business, Data, Dynamic Validation, Dynamic VLOOKUP, Excel, Excel 2010, INDEX, MrExcel, Offset, spreadsheets, technology, tutorial, Validation, VLOOKUP, Worksheet.