You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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.
Bill Jelen is the host of MrExcel.com and the author of 34 books about Microsoft Excel.
The article which is gaining the most votes.. "Using VLOOKUP inside Data Validation " - Can be done with Indirect function as well... So there is a workaround for this... Whereas Idea#3 "INDIRECT() to point to a variable sheet " is the most useful according to my understanding :) Anyway each and every article here was very useful... learned a lot of tricks from this... I am an avid lover of VLOOKUP and would like to use this function anywhere and everywhere possible :)