Question about sorting two lists

[madmanmac]

I have two very long lists. Each has lists contains names and a corresponding number. Some names appear in each list.

I am looking for a way to search through the lists, find the names that are common to each list and then add the two numbers that go with that name.

I tried using the MATCH function and can use it to find which names appear in each list but cannont figure out how to do the addition part.

Any suggestsions?

Thanks!

[justbrewit]

Something like this.....


A B C D E
(totals)
Adam 6 Adam 9
Eve 7 Steve 8


D1+IF(ISNA(VLOOKUP(C1,$A$1:$B$2,2,FALSE)),0,VLOOKUP(C1,$A$1:$B$2,2,FALSE))

[justbrewit]

looks like my spacing got all screwed up but names are in A and C columns, numbers in B and D. Your totals are in E