Sumproduct - number & text
Hi Kayshap
Try this:
With the criteria you want to look up in E1 and F1
=INDEX($D$2:$D$100,MATCH($E$1&$F$1,$B$2:$B$100&$C$ 2:$C$100,0))
this is an array formula entered by pressing Ctrl. Shift and Enter together.
This should return the value from the row in column D where the cells in
columns B and C have the values specified in E1 and F1.
"Kashyap" wrote:
Hi, I have number in colB & text in Col C,D
I was trying sumproduct to go the data from colD looking at Col B & C
something like below.. But result is #VALUE!
=SUMPRODUCT((Sheet2!$C$2:$C$100=$C$2)*(Sheet2!$B$2 :$B$100=R4)*(Sheet2!$D$2:$D$100))
Can someone help me on this pls...
|