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]
“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!
From the Blog.Office.Com Excel Blog page, Microsoft’s Emily Warn puts the Wraps on “VLOOKUPWEEK 2012”
“VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside–Excel experts created a crazy number of useful and innovative applications of VLOOKUP in seven days. The week might be over, but thanks to the enthusiasm of the Excel community and to the Web, the information will continue to instruct Excel users at all levels of expertise. So thanks, Bill, and …” … To Read the Entire Blog.Office.Com entry by Emily Warn Click Here – and don’t forget to enter your vote in the poll on Emily’s post!
Click To Go & Vote In The Poll!
The Microsoft Office Blog Excel Page can be found Here: http://blogs.office.com/b/microsoft-excel/
Thank you Emily!
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!
VLOOKUP WEEK is moving along and Bill brings us another use of VLOOKUP combined with the ‘Consolidate Function’.
The QUE blog checks in for some mid-week Excel-lence:
“For day three of VLOOKUP Week, this two-part video podcast featuring Bill Jelen demonstrates the VLOOKUP Formulas in Excel. Bill Jelen, author of Excel 2010 In Depth offers a beginning and advanced look at VLOOKUP in these two videos. In video 1, matching data from two lists:! …Click here to continue on to the Videos presented at Que Publishing Blog.
From Emily Warn at Microsoft Excel Blog:
“In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of formulas that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an Excel workbook, speeding up getting work done. But that’s about it.”… Click here to continue at Blogs.Office.Com
In the spirit of “VLOOKUP WEEK 2012” [march 25th – March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I have received the workbook back from my manager and now I need compare the data [the original data with the new data] to find out what was deleted, what was added and what was changed. Today Bill shows us how to work with VLOOKUP to find the answers to our questions.
From QUE Publishing:
“It is day #2 of VLOOKUP Week and who better to give the lay of the VLOOKUP land than Paul McFedries, author of “Formulas and Functions for Excel 2010“. In the following post, he breaks it down nice and neat like…” Click Here To Read More…
From the Book “Excel For Marketing Managers“, by Ivana Taylor and Bill Jelen, we are offering a free excerpt as a PDF Download. From the Chapter ‘Disciplining Data’, discussing VLookup [pages 84 and 85]. Click Here to Download the PDF Excerpt.
You may read more about the book “Excel For Marketing Managers“, by Ivana Taylor and Bill Jelen Here.
QUE Publishing – a publishing imprint of Pearson, founded in 1981 – has joined us for “VLOOKUP WEEK 2012”! You may read the press release on the here on the QUE Publishing Blog. An excerpt from the release reads:
“QUE author Bill Jelen has declared March 25 – 31, 2012 to be VLOOKUP Week. He has invited all of his fellow Excel gurus to make one or more VLOOKUP-themed posts on their website during the week. At his MrExcel.com website, he will offer five podcasts about VLOOKUP and giveaways each day. Posts from across the web will be curated into a special blog at vlookupweek.wordpress.com.”
To read the entire blog entry, click here.
Be sure to join us March 25th to March 31st, 2012 for VLOOKUP WEEK 2012 – Right here!!