Tag Archives: spreadsheets

Mike and Bill Debate: “=LOOKUP vs. @LOOKUP”

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!