Unfortunately, that won't work.

I have names in Sheet 2!Col A and weights in Sheet 2!Col C.

I also have names in Sheet 1!Col A.

The Sheet 1 range is nothing like the same size as the Sheet 2 range and has
data only intermittently.

I need to "walk" Sheet 1!Col A, every time I find a value, look up that
value in Sheet 2!Col A and return the value in Sheet 2!Col C, and then sum up
all the corresponding returned values in Sheet 1!Cell Z.

I'm pretty sure this can be done in a simple formula without resorting to
hidden columns and macros, etc. I just haven't figured out how to do it.

Someone here does, I'm sure. Are you out there? PLEASE! :-)

"Sheeloo" wrote:

If you have names in Col A (A1:A100) and amounts in Col B (B1:B100)

then this will give you the total in Col B where name is Adam
=SUMPRODUCT(--(A1:A100="Adam"),(B1:B100))