VLOOKUP week wraps up: vote for your favorite post

VLOOKUP week ended. The idea of Excel MVP Bill Jelen, inspired the idea of all VLOOKUP, VLOOKUP track Oden haikus, vampires, and shark attacks.

If all beiseite-fun - Excel experts crazy several useful and innovative applications of VLOOKUP in seven days created. The week could be but thanks to the enthusiasm of the community Excel and on the Web, the information continue to have Excel users at all levels of experience. So thank you, Bill, and thanks to Excel community.

Here, Bill's wrap-up:

Many people from around the world submitted VLOOKUP week many exciting tips and tricks about VLOOKUP. I moved seven of the most innovative contributions for your enjoyment. Do she these contributions from one you like the best? Take the two-second poll below and let us know. The top vote-getter will win under the name "Great White Shark" VLOOKUP week and a copy of my book Microsoft Excel 2010 in depth.

= INDEX (MATCH (EXACT case search by Tom Urtis=RELATED() in Powerpivot by Rob Collie=INDIRECT() to a variable sheet by James Chen= VLOOKUP with select search links from Richard Schollarusing VLOOKUP in validation by JP PintoVLOOKUP, OFFSET, and MATCH double lookup by Javier Guillenimproving VLOOKUP with two VLOOKUPS from Charles Williams speed ))

Bill Jelen is the host of MrExcel.com and author of 34 books on Microsoft Excel.

View the original article here