index match if iferror

[rjmdc]

hi
this is the original formula that was "created" for my books
=IF(IFERROR(INDEX(Terminations[termination_reason], MATCH(1, (Terminations[tabs_id]=[@[TABS ID]])*([@[Service Month]]>=Terminations[termination_date]), 0), ), "")="terminated", 0, SUMIFS('Budget Summary Periods'!G:G, 'Budget Summary Periods'!$B:$B, [@[TABS ID]], 'Budget Summary Periods'!$F:$F, "<="&[@[Service Month]], 'Budget Summary Periods'!$F:$F, ">="&[@[Budget Start Date]]))

i need instead of index termination_reason to use termination_date only if >0
i dont know and i've tried to correct the fomula but its not working
the solution i was asked to try:
=IF(IFERROR(INDEX(Terminations[termination_date], MATCH(1, (Terminations[tabs_id]=[@[TABS ID]])*([@[Service Month]]>=Terminations[termination_date]), 0), ), "")>0, 0, SUMIFS('Budget Summary Periods'!G:G, 'Budget Summary Periods'!$B:$B, [@[TABS ID]], 'Budget Summary Periods'!$F:$F, "<="&[@[Service Month]], 'Budget Summary Periods'!$F:$F, ">="&[@[Budget Start Date]]))
doesnt wrk the entire columns are filled with 0

what am i doing wrong?

 

[rondeondo]

please post a sample of your data. it looks like the formula refers to many things
When building such a formula I like to spread it across multiple columns to break it up into it's bit. I realise it's harder when you have inherited something like this.

I think there may be a problem with your match, without seeing how your data works this is just a guess, but the match(1..... bit will return something for the first line it finds with a 1 in it. But I'd say it's always finding something and it's >0 so you're getting 0's out.