I am trying to use vlookup to take a name from colum a on one work book and
look for numbers in another work book. I can do that fine. The problem is
that in the second work book there are many numbers for the same person and I
need these to be added together and a total of these numbers reported in
colum B in the first work book. Can anyone help