Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » VLOOKUP (RSS)

Browse by Tags

  • 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 for a page ID on another worksheet, find a corresponding page name, and plunk...

  • VLOOKUP: No more #N/A

      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 you’re new to VLOOKUP, we have a free, entry-level training course available on Office.com that can get you started. If you’re familiar with VLOOKUP, you’ve no doubt seen this before: #N/A errors really...
    Filed under: ,

  • =VLOOKUP (uhh…now what?)

    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 type “VLOOKUP” into the search box in Help or on our web site. The “VLOOKUP” query appears to represent a bunch of different questions. Certainly, one of the main ones has to do...
    Filed under: , ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.