use Vlookup for sum all found value?

I

Ivan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top