Today, in Episode #1328, Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen look at a question posed by ‘Raymond30031' from YouTube. Basically, arranging 2 Criteria with Multiple Ranges to give us our result, Mike and Bill use the INDEX, INDIRECT and MATCH Functions to lookup the data. Also learn keyboard shortcuts to maneuver through your spreadsheets easily!
AND
“Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Coming early 2011!!]
For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. Entry filed under: Dueling Podcasts, Excel 2010, Excel 2010 In Depth, Slaying Excel Dragons. Tags: Bill Jelen, business, Data, Dueling Excel, Excel, Excel 2010, formula, Function, Functions, INDEX, INDIRECT, Learn Excel, MATCH, MrExcel, shortcuts, Spreadsheet, spreadsheets, technology, tutorial, VLOOKUP, Workbook, Worksheet.
Be the first to like this post.
