Too many arguments for this function error

[chrono2483]

I am trying to use the following formula - to contain 2 IF statements:

=IFERROR(IF(OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,3,,)="--:--",OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,),OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,3,,)),if(offset(index($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,)="--:--",offset(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,,,),offset(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,)),"")


I get an error that I've entered too many arguments for this function. Is there any way to condense, while keeping the OFFSET formula? I thought an IF/OR might work, but not so much.

 

[RoryA]

Can you use a helper column for this part:
MATCH($M4,$A$1:$A$5000,0)
rather than repeating it?

 

[konew1]

You have 2 sets of results to return if the IFERROR finds an error in the first section.

=IFERROR(
IF(OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,3,,)="--:--",OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,),OFFSET(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,3,,) )

If the first IF condition returns an error then the following will be evaluated
,if(offset(index($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,)="--:--",offset(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),4,,,),offset(INDEX($A$1:$A$5000,MATCH($M4,$A$1:$A$5000,0)),5,3,,))

and this bit is surplus
,"")