IFERROR help please!

[4danny]

Hi.
I need some assistance with finishing off this formula:

=IFERROR(INDEX(N3:N1500,MATCH(AA3&"team",B3:B1500&H3:H1500,0)),0)+IFERROR(INDEX(P3:P1500,MATCH(AA3&"team",B3:B1500&V3:V1500,0)),0)

At the moment I'm getting the correct results up until there is no data entered in the N3:N1500 and P3:P1500 cells that match's the rest of the formula, at which point I get a 0.
I need the 0's that are to the left of the comma and inside the ride parenthesis and the end of each statement to return a blank cell if there is not data in cells N3:N1500, but if I change the 0 to "" i get the #VALUE! error.

To try and help you understand this formula a little better, the data I,m trying to match is from sporting competition schedule and results.

N3:N1500 and P3:P1500 are the scores for away team, and home team.
AA3 is the date I want to match it to.
"team" is the team name i want to match it to.
B3:B1500 is where the dates are found.
H3:H1500 is where the away team is found.
P3:P1500 is where the home team is found.

When I have all the team's scores in a column, I will be able to get average scores, etc. Having 0 in the future dates row affects a whole bunch of other formula results I have on the sheet.

I appreciate any assistance.

[Richard Buttrey]

Hi and welcome to the forum.

Can I suggest you upload the workbook so that we can see the request in context.