CODEWITHSUNDEEP
excelif-statementsearch
Sagar Rana
Sagar Rana

Reputation: 33

Excel Search & compare 2 or more cell for result

I'm little struggle on my this project. Please see a photo I attached enter image description here 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

Upvotes: 0

Views: 36

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

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)

enter image description here

Upvotes: 1

Related Questions