It all started when spreadsheet guide Bill Jelen (aka MrExcel) declared that 25-31 March would be VLOOKUP Week.
Perhaps because the idea has happened before (Chandoo staged a similar online event in 2010), the Excel MVP community responded enthusiastically with several others weighing in with their contributions. The Microsoft Excel Blog team got in on the act and reported that VLOOKUP Week took on a life of its own.
“Bill finds himself with VLOOKUP t-shirts, coffee mugs, and a theme song and logo,” the blog reported.
A shark was selected as the logo for VLOOKUP week because VLOOKUP “strikes terror into the hearts of Excel beginners”, reported Debra Dalgleish on her Contextures blog, which celebrated the occasion by demonstrating how the function could be used to analyse shark attack data in the USA.
Since lookups are one of the most popular topics in ExcelZone, we thought we’d join in the fun too. If you fancy an afternoon (or weekend?) of VLOOKUP education and exploration, here are some of the goodies available:
If this collection has got you excited about Excel lookup techniques, but made you regret that you didn’t hear about VLOOKUP Week in time, don’t despair. The response was so overwhelming that Bill Jelen announced, “We’re going to need a bigger week!” In the world of Excel MVPs, VLOOKUP Week goes on forever.
Have a look at the resources available, and let us know if we've missed any of your favourite VLOOKUP tricks.