Dueling Excel – “=LOOKUP vs. @LOOKUP”: Podcast #1550

April 20, 2012 at 3:29 pm


Going back to “VLOOKUP WEEK 2012” Mike ‘ExcelisFun’ Girvin and Bill ‘MrExcel’ Jelen look at the ‘LOOKUP’ Function. Taking cues from an email Bill received from Dan Bricklin [co-founder/inventor of VisiCalc] Bill argues the point that “=LOOKUP” is ambiguous in Microsoft Excel when the Data Set Table is ‘square’. Mike, on the other hand, thinks that “=LOOKUP” is not an ambiguous Function in that scenario; that it is intuitive and dynamic. Follow along with Episode #1550 to hear the debate and decide for yourself.

Dueling Excel Podcast #106…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]

and

“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”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Advertisements

Entry filed under: Bill Jelen, Dueling Podcasts, eLearning, Excel, Excel 2010, Excel for Educators, Excel For Teachers, Excel in Education, ExcelisFun, For Educators, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel from MrExcel, Mike Girvin and Bill Jelen, MrExcel Podcast, MrExcel Products, New MrExcel Publication, Slaying Excel Dragons, VLOOKUP WEEK. Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , .

Learn Excel 2010 – “Print Each Record with a Macro – Part IV of IV”: Podcast #1549 Learn Excel 2010 – “Add ‘N’ Percent”: Podcast #1551


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 740 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: