“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!
“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
XLCalibre says, “COUNTIF Me In” with this entry to VLOOKUP WEEK 2012.
The purpose of the VLOOKUP function is to find your chosen value in a table of data and tell you what the corresponding value is in another part of that table… Currency conversion is essential when calculating international reward programs, like bonuses or salary review. You’ll usually need to work from a budget in a single currency to show the overall cost. So we’re going to use currency conversion to demonstrate the VLOOKUP function. To Read More Click Here to go to XLCalibre’s Lesson
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.”
VLookup Week is gaining momentum as we move into the weekend – The Microsoft Office ‘Excel Blog’ has loosed the catch: “Ride The Shark! It’s VLOOKUP Week March 25-31, 2012” and Microsoft Excel Blog will be particapting as well:
“We’re participating, too, thanks to Bill. We’ll be publishing a five-part tutorial from him, one segment for each day of the week–with videos.”