MATCH help

[Kailis]

I need some assistance with using Excel 2007 - match

Below is the current formula that I am using
=IF(ISERROR(MATCH(E2,C:C,0)), 0, MATCH(E2,C:C,0))

I am attempted to get the value of the BOA column referenced from the match result. See the image of the spreadsheet/formula that I am using.

Can anyone assist me with this issue. Thank you.

[ChemistB]

Try this

=IF(ISERROR(MATCH(E2,C:C,0)), 0, INDEX(B:B,MATCH(E2,C:C,0)))
does that work for you?

[daddylonglegs]

You could also use IFERROR function, i.e.

=IFERROR(INDEX(B:B,MATCH(E2,C:C,0),0)

[Kailis]

The solution from ChemistB works perfectly. The other suggested formula doesnt work.

I have another question with .. I realized that in column C titled BP have multiple occurences of the same # with another balance

B_______C
$1.00 10001
$1.00 10002
$2.00 10001

Is there a formula that I could use to find the duplicates in column C and combine the matching balances from column B?

I hope this makes sense. Thank you again for your assistance.

[daddylonglegs]

The other suggested formula doesnt work.

I missed a parenthesis, should be

=IFERROR(INDEX(B:B,MATCH(E2,C:C,0)),0)