Subscribe!

If you have not used vlookup, give it a shot! It is my (as well as many others!) favorite Excel function. I use vlookup almost daily. The format is…

=VLOOKUP(a1,a13:N20,2,FALSE)

This function looks for what is in cell a1, in a13:a20. if it finds an exact match, it returns what is in cloumn 2 of the a:n table (in this case column b). The false is the switch to tell it to find an exact match, if you leave off false you will get the closest match.

You can find a list of all Excel Functions at ExcelYogi.com

Now…Go try it!

***Updated***
Excel Yogi has created the new VlookupPlus add in. Read more about it here:
Vlookup Add in

If you found this article helpful, buy me a cup of coffee!

Related posts:

  1. Vlookup Multiple Criteria in Excel The standard vlookup function allows for one condition to be...
  2. Multiple Condition Vlookup Function Add-in – Excel The question we are asked most often by ExcelYogi readers...
  3. How to Use ISERROR Function in Excel The ISERROR function is a versatile one that is very...
  4. Excel Function “AND” AND function use...
  5. Vlookup the Last Occurence of an Item – Excel The title of this post is slightly misleading. We will...

This entry was posted on Thursday, October 23rd, 2008 at 12:31 pm and is filed under Excel Quick Tricks, Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.