mix vlookup and hlookup or another function

[arnaud23]

Hi everyone,

I have got an issue. In the file enclosed, you will see that I would like to input the data from the left tab into the right tab. I have tried with a vlookup, a hlookup (but with the difference of dispositon, it's not possible) or even a pivot table but it seems it does not work. How would you manage to do that ? Thanks a lot.

Arnaud

[daddylonglegs]

Hello arnaud,

You could try this formula in G7 copied down and across

=SUMPRODUCT(--($A$14:$A$43=G$6),--($B$14:$B$43=$F7),$C$14:$C$43)

note: if any combination of country and category occurs more than once in your list it will sum the corresponding numbers together.....

[arnaud23]

that's perfect. Thanks a lot.

Arnaud