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 thanks Excel community.
Here is Bill’s wrap-up:
During VLOOKUP week, many people from around the world submitted lots of fascinating tips and tricks about VLOOKUP. I pulled out seven of the most innovative posts for your enjoyment. Which one of these submissions do you like best? Take the two-second poll below and let us know. The top vote-getter will be named the “Great White Shark” of VLOOKUP Week and will win a copy of my book Microsoft Excel 2010 In Depth. The voting ends on Monday, April 9th, 5 pm EST.
- =INDEX(MATCH(EXACT for case sensitive lookup from Tom Urtis
- =RELATED() in PowerPivot from Rob Collie
- =INDIRECT() to point to a variable sheet from James Chen
- =VLOOKUP with CHOOSE to lookup left from Richard Schollar
- Using VLOOKUP inside Data Validation from JP Pinto
- Using VLOOKUP, OFFSET, and MATCH for double lookup from Javier Guillén
- Improve VLOOKUP speed with two VLOOKUPS from Charles Williams
Bill Jelen is the host of MrExcel.com and the author of 34 books about Microsoft Excel.