I'm little struggle on my this project. Please see a photo I attached All I want is A3 and B3 match (Drop down List) then automatically come salary on C3 if match but if not match then show 0.

Thank You

CodePudding user response：

Try SUMPRODUCT() like-

=SUMPRODUCT(($J$3:$J$5=A3)*($K$3:$K$5=B3)*$L$3:$L$5)

Or FILTER() function like-

=FILTER($L$3:$L$5,($J$3:$J$5=A3)*($K$3:$K$5=B3),0)