Subscribe!

The question we are asked most often by ExcelYogi readers is how can I use vlookup with multiple criteria or conditions. There are several solutions but some can be pain staking and unrealistic. Knowing that the Excel world is missing this feature, Excel Yogi has created a VLookup addin that will extend the built in Vlookup features by a mile.

The VlookupPlus add-in allows you to use the following functions:

  • vlookup2()  Look up a result based on two criteria / conditions
  • vlookup3()  Look up a result based on three criteria / conditions
  • vlookup4()  Look up a result based on four criteria / conditions
  • vlookupinstance()  Returns the nth occurence of an item
  • vlookupall()  Returns all results for the chosen condition

Detailed Examples:
vlookupplus

Based on the image above, check out some example results using the VlookupPlus addin:

Function: =vlookup2(A2:E10,5,”Larry”,”Meyer”)   Result: Mitchell
Function: =vlookup3(A2:E10,5,”John”,”Smith”, 265)  Result: South
Function: =vlookup4(A2:E10,5,”John”,”Smith”, 212,”black”)  Result: Northwest
Function: =vlookupinstance(“John”,A2:A10,D2:D10,3)  Result: Red
Function: =vlookupall(B2:C10,”Smith”) Result: 212, 265, 212

The addin comes with simple step by step install instructions that everyone can follow.

The Excel VlookupPlus Add-in is available below for a donation of $2.99. The download will be emailed automatically/immediately after donation is processed.

Amount Description
$2.99 VlookupPlus: Microsoft Excel Add-in, compatible with Excel versions 2000 and later (PC) Secure Online Payments and Credit Card Processing by Plimus

Thanks,
Joseph Harris

Related posts:

  1. Vlookup Multiple Criteria in Excel The standard vlookup function allows for one condition to be...
  2. Vlookup – My Favorite Function Vlookup...
  3. Vlookup the Last Occurence of an Item – Excel The title of this post is slightly misleading. We will...
  4. How to Use ISERROR Function in Excel The ISERROR function is a versatile one that is very...

This entry was posted on Monday, March 16th, 2009 at 2:51 pm and is filed under Business Analyst, 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.

3 Responses to “Multiple Condition Vlookup Function Add-in – Excel”

  1. Excel Yogi’s » Blog Archive » Vlookup Multiple Criteria in Excel on March 16th, 2009 at 2:58 pm

    [...] Multiple Condition Vlookup Function Add-in – Excel [...]

  2. Excel Yogi’s » Blog Archive » Vlookup - My Favorite Function on March 17th, 2009 at 1:53 pm

    [...] Multiple Condition Vlookup Function Add-in – Excel [...]

  3. Excel Yogi’s » Blog Archive » Vlookup the Last Occurence of an Item - Excel on March 18th, 2009 at 11:20 am

    [...] Multiple Condition Vlookup Function Add-in – Excel [...]

Leave a Reply

You must be logged in to post a comment.