#### chrono2483

##### Board Regular

- Joined
- Aug 23, 2014

- Messages
- 157

=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.