Results for:
VLOOKUP

• Your top 10 favorite Excel posts of 2012

  7 Jan 2013

  There's an Excel community out there that continually wants to learn new tricks, and there are lots of people just discovering Excel's capabilities who want to join in. The most popular posts of 2012 that were about the current version of Excel reflect that mixed audience. But the popularity ranking...
• And the winner of the VLOOKUP Great White Shark Award is...

  11 Apr 2012

  JP Pinto! Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week . He won a copy Bill Jelens book Microsoft Excel 2010 In Depth . You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week . JP...
• VLOOKUP Week wraps up: Vote for your favorite post

  4 Apr 2012

  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...
• VLOOKUP Tutorial: Updating prices in a master price list

  28 Mar 2012

  MVP Bill Jelen has created this 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 the VLOOKUP function and its benefits, but that you don't really know how or when you might use it. Bill uses the example...
• Today's giveaway: Odes to VLOOKUP (It ain't over until the formulas stop singing)

  27 Mar 2012

  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. He decided today's VLOOKUP...
• You asked about VLOOKUP

  23 Mar 2012

  (Note: In honor of VLOOKUP Week, March 25-31, we're re-publishing this round-up of VLOOKUP resources on Office.com and other places. Thought some of you might want to brush up on your skills before you write that post.) People are crazy for Excel's VLOOKUP function, and why not? Among other things, VLOOKUP...
• Ride the Shark! It's VLOOKUP Week March 25-31, 2012

  22 Mar 2012

  What strikes terror into the hearts of Excel beginners? VLOOKUP! Excel power users, though, can't live without it. Excel MVP Bill Jelen has declared March 25 - 31, 2012 to be VLOOKUP week . He's invited his fellow Excel experts to publish VLOOKUP posts on their sites during the week. At MrExcel.com ...
• VLOOKUP: No more #N/A

  6 Oct 2010

    Today’s blog post is brought to you by Anneliese Wirth, who writes about Excel for Office.com.   To grow your skills with Excel, it’s helpful to familiarize yourself with a core set of functions, or predefined formulas that are built into Excel. One of my all-time favorites is VLOOKUP. If...
• =VLOOKUP (uhh…now what?)

  31 Aug 2010

  Today’s post is brought to you by Anneliese Wirth, a writer on Office.com. On Office.com , the term “VLOOKUP” frequently bubbles up in our list of high-volume search queries. My job is to figure out why this is and what specific information people are actually looking for when they...