sumproduct with text
 

=INDEX(C2:C30,MATCH(1,INDEX((A2:A30=N22)*(B2:B30=Q 22),),))

Normally ENTER


"Kashyap" wrote:

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..