Hello:

I have a table that is monthly retrieved from an accounting
application. I post a table as an example:

Ref Product Seller Profit

1 A 1 4
2 B 1 7
2 B 2 9
3 C 1 3

In another table I must have the following results:

Ref Profit

1 4
2 7
2 9
3 3

There is no way I can change the reference numbers automatically. As
you can see, I can't use vlookup as it stops in the first cell that
matches the "2" Ref, retrieving always the same value 7.

The question is simple: how do I retrieve the "9" in the second "2"
reference ?

Thanks

M