I have two sets of data. The first is an ever growing list of names, which we'll call
Names (not necessarily a named range). Something like:
The second is also a growing set of data, includes (but is not limited to) the above names, and has some corresponding values. We'll call this
What I'd like to do is iterate through
Data, looking any items defined in
Names, then summing their corresponding values. In this case, it'd return
I immediately thought to use VLOOKUP, as that's the normal function to use for matters like this. However, VLOOKUP seems to only accept a single value as its search key, so I'm at a loss.