People are crazy for the Excel function VLOOKUP, and why not? Among other things, VLOOKUP is known for his rugged good looks and unique martial arts ability.
All seriousness VLOOKUP is one of the most common and versatile functions in Excel. Typically, use you quickly look it up and to extract specific bits of information from a large list of data. The following example I VLOOKUP to search for a page ID to a different worksheet, find a corresponding page name need have, and to take, that page names back in the cell, where I entered the formula. (Yes, "put you down.")
Because VLOOKUP is one of the top search engines queries on Office.com, we collect some questions about how you have used it. Here is a collection of resources, with which you can learn or fix.
If you know not much about VLOOKUP, you start here.
Video-based training that provides detailed information about the VLOOKUP, including a Übungsdatei and a quick reference card.
Help article, which describes the formula syntax in detail and provides examples. Only the facts, Ma'am.
Printable card for those who use the VLOOKUP rarely and therefore need help remembering the function's arguments (in plain English, the information between the brackets the function says, is what to do).
Video series which covers not only VLOOKUP all reference features in Excel. (If you don't know video series on YouTube about Mike Girvin "Excelisfun", take a look and see what you think.) (I find these videos to be enormously helpful.)
Once you locate it, problems can occur. These resources can help.
Printable map, the techniques to avoid or manage # N/A error explains.
Post by MVP Greg Truby , of these very frequently asked questions addresses:
How can I values based on more than one column? Why do I get a # N/A error, although the search value is valid?What can I do if I return a value, based on the left side of the lookup field?Article by MVP Bill Jelen , that explains a little more about this last point above-that VLOOKUP uses always the first column into a lookup table as a starting point. If not, that work for your situation, you can INDEX and MATCH instead of VLOOKUP.
Free tech support forum to specific questions about VLOOKUP and get answers by Excel MVPs and other Excel users. Here are, for example, existing threads across multiple VLOOKUPs and conditional VLOOKUPs.
No doubt there are many useful articles and tutorials are. Have a personal favorite, or a good tip, feel free you please share it with us.
--Anneliese Wirth
No comments:
Post a Comment