lundi 30 mars 2015

How to use vlookup with the first entry being a list instead of a value

Say i have a data set


apple 11


orange 22


grape 33


and a list


apple


grape


is there anyway i can look up (and sum up) the values in column B based on the sub-list? In this case, my sum will be 44


I tried index match and vlookup but can't seem to lookup using a list. I also google extensively but all search results i got were related to lookup using multiple criteria (array) which i know how to do.


Please help?


In this case, it'd be easy to add up two individual lookups. However, in my real example, my list has over 10 values so it wouldn't be too efficient


Thank you very much!


Aucun commentaire:

Enregistrer un commentaire