Re: use Vlookup for sum all found value?

From: Fernando Ortiz (lufortiz_at_tutopia.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 10:47:17 -0500

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" <ivan@fake.email.com> escribió en el mensaje
news:exjpvTmYEHA.556@tk2msftngp13.phx.gbl...
> Hi,
>
> I am new here and have a problem hope I can get help in here!
>
> I have two work*** "W1" and "W2"
>
> In W1 work***, 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 work***.
> 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
>
>