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