ExcelBanter - Matching two values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Matching two values (https://www.excelbanter.com/excel-worksheet-functions/220159-matching-two-values.html)

Anna Wood

Matching two values

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[_2_]

Matching two values

=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="In surance")*Sheet1!D1:D3)

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

"Anna Wood" wrote in message
...
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

Anna Wood

Matching two values

That did the trick - thank you!

"Laura Cook" wrote:

=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="In surance")*Sheet1!D1:D3)

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

"Anna Wood" wrote in message
...
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

All times are GMT +1. The time now is 08:13 AM.