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