Matching two values

[Anna Wood]

Not quite sure how to write the formula to return value for D1 in new
worksheet. I need to match the values for both B1 and C1.

B C D
1 ABC Insurance $100
2 ABC Taxes $200
3 DEF Insurance $150

 

[Laura Cook]

=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="Insurance")*Sheet1!D13)

You can substitute the "text" for a cell that the criteria is entered into.

 

[Anna Wood]

That did the trick - thank you!

=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="Insurance")*Sheet1!D13)

You can substitute the "text" for a cell that the criteria is entered into.