• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vLookup with multiple lookup_value

P

praves

New Member
Hi Chandoo


I am struggling with this fact. I need to look for 2 values in my table so pass me corresponding value in the same table but problem is vLookup does look for only 1 value (or condition). Is it possible ?


Best Regards,

Praves
 
Hi ,


An alternative is to lookup the concatenated values , so that when you lookup an item , you are actually looking up a concatenated value.


For example , if your data consists of one column for country codes , and another for customer codes , if you wish to search for a customer code of "1102" in a country with code "PL" , you can concatenate the country codes and the customer codes in a helper column , so that now you can lookup the value "PL1102" in this helper column.


This helper column will have to be within the data table , in case you want to use the VLOOKUP function , but can be outside the data table in a remote column if you can use the MATCH and INDEX functions.


Narayan
 
Hi Praves,


Sum product would be a good option. You can use more than 2 conditions.

Check out Chandoo's post on Sumproduct, in the link below:


http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/


Regards,

Mano
 
You must log in or register to reply here.
Back
Top