The job in your example can be done by recording a simple macro that copies
column A (Ref) in table 1 to column A in table 2 and column D (Profit) in
table 1 to column B in table 2. Or is there something more complicated to be
done?

Regards,
Stefi


€žMaxtrix€� ezt Ã*rta:

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