Excel

VLOOKUP Week wraps up: Vote for your favorite post

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.  Now Bill wants you to vote for your favorite. Top vote-getter will be named the “Great White Shark” of VLOOKUP week!

Excel

VLOOKUP Tutorial: Updating prices in a master price list

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. This tutorial assumes you’ve heard about VLOOKUP and its benefits, but that you don’t really know how to use it. Bill uses the example of updating prices in a product list to introduce the value of this time-saving function.

Excel

Today’s giveaway: Odes to VLOOKUP (It ain’t over until the formulas stop singing)

Bill Jelen found it. Erica Rhein started it.  She posted a comment on Facebook declaring her complete dependence on VLOOKUP.  “I use Pivot Tables and VLOOKUP every day. I would be screwed at my job without it.”  To Bill’s formula-possessed mind this statement equals a love poem. So he decided today’s VLOOKUP Week door prize would go to the best Ode to VLOOKUP. Check out the haikus and poems about undying…

Excel

You asked about VLOOKUP

People are crazy for Excel’s VLOOKUP function, and why not? Among other things, VLOOKUP is known for its rugged good looks and unparalleled martial arts ability. In all seriousness, VLOOKUP is one of the most widely used, versatile functions in Excel. You typically use it to quickly look up and extract specific bits of information from a big list of data. In the following example, I’ve instructed VLOOKUP to search…