sumproduct with text

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

 

[Ashish Mathur]

Hi,

Try the following:

=INDEX($A$2:$C$10,MATCH(1,($A$2:$A$10=E2)*($B$2:$B$10=F2),0),3)
--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com