K
Kashyap
Hi,
I have Ref# in col A, Names in Col B and Designation in col C.. Both Col B &
C are text
I tried below formula to lookup both Col A & B and get Col C, but the result
i'm getting is 0
I tried same formula with numbers which worked fine..
=SUMPRODUCT(--(N22=A2:A30),--(Q22=B2:B30),C2:C30)
Can anyone help me out with this pls..
Thanks..
I have Ref# in col A, Names in Col B and Designation in col C.. Both Col B &
C are text
I tried below formula to lookup both Col A & B and get Col C, but the result
i'm getting is 0
I tried same formula with numbers which worked fine..
=SUMPRODUCT(--(N22=A2:A30),--(Q22=B2:B30),C2:C30)
Can anyone help me out with this pls..
Thanks..