Hello Vletm, Could you please elaborate didn't understand your point. thank youriya
VlookUp works correct
... but Your way to use it, it gives different result than You seems to expect.
View attachment 64032
to get those 2 & 3 ... You should able to get row #33 values ... not row #32.
Both of those are 'CanadaERS'.
hello
you can to use this
Code:=SUMPRODUCT(Input!$D$2:$F$1000,((Input!$B$2:$B$1000=$A2)*(Input!$C$2:$C$1000=C$1))*(Input!$D$1:$F$1=$B2))
Hi ,
Try this :
=SUMIFS(INDEX(Input!$D$2:$F$57,, MATCH($B2, Input!$D$1:$F$1, 0)), Input!$B$2:$B$57, $A2, Input!$C$2:$C$57, C$1)
Enter this in cell C2 and copy across and down.
Narayan