I'm trying to update a new spreadsheet and need to match two values from the
old spreadsheet.

Example

B1 C1 D1
ABC Insurance $100
DEF Insurance $200
ABC Taxes $300

In the new spreadsheet, the columns B and C are the same - I just need to
update the number for D. How do I write a formula to match both the value in
B1 and C1 and return the value in D1?

Double post - please disregard

"Anna Wood" wrote:

I'm trying to update a new spreadsheet and need to match two values from the
old spreadsheet.

Example

B1 C1 D1
ABC Insurance $100
DEF Insurance $200
ABC Taxes $300

In the new spreadsheet, the columns B and C are the same - I just need to
update the number for D. How do I write a formula to match both the value in
B1 and C1 and return the value in D1?

try this
Sheet 1 - old values

In sheet 2 , Cell D1 put this formula
=INDEX(Sheet1!D$1:D$3,MATCH(B1,Sheet1!B$1:B$3,0)*M ATCH(C1,Sheet1!C$1:C
$3,0),0)


On Feb 11, 12:47*am, Anna Wood
wrote:
I'm trying to update a new spreadsheet and need to match two values from the
old spreadsheet.

Example

B1 * * * * *C1 * * * * * * * D1
ABC * * * Insurance * * $100
DEF * * * Insurance * * *$200
ABC * * * Taxes * * * * *$300

In the new spreadsheet, the columns B and C are the same - I just need to
update the number for D. *How do I write a formula to match both the value in
B1 and C1 and return the value in D1?