On Sheet 1, you have Customer Data with Subtotals added by the Subtotal command. On Sheet 2, you have a list of Customers. How do you do VLOOKUP from Sheet 2 to get the Total for each Customer from the Data of Sheet 1? This question was posed during my Fort Wayne seminar. In Episode #1882, I am offering two(2)  possible solutions to this problem.

And speaking of Power Excel Seminars, Click Here for information on the May 9, 2014 Tampa Power Excel Seminar.

LE10_180WP

…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!

And if you’re looking to upgrade to Excel 2013, then check out:

InDepth_180WP

Microsoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify.

Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!