Tag Archives: Dan Bricklin

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!

Advertisements

Bill Jelen: “From 1979 – VisiCalc and LOOKUP”!

You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began!