Hi Ivan

If your task is no more complex, you can use the sumif function, the on line
help is useful in this case.

The array's formulas are little bit more complex and need a some knoweledge
about this.

Regards

Fernando Ortiz

"Ivan" escribió en el mensaje
...
Hi,

I am new here and have a problem hope I can get help in here!

I have two worksheet "W1" and "W2"

In W1 worksheet, it has a column "emp_pin" which is unique. This value is
used in the
Vlookup function to find a numeric value "Paid" in W2 worksheet.
If "W1" and "W2" are one to one relationship, it will work fine. However
I
have encountered
the one to many relationship, it means one row in "W1" has many rows in
"W2". I just wonder if I can sum up all the found value "paid" in "W2".

should I still use Vlookup or there is something out there I can use?

Thanks...
Ivna