Spill to display as blank

[jcontois]

Hello community, 

I am trying to automate meeting dates dependent on a character (currently "^") some rows will have this and another character ("_"), some will have "^" and some rows will have "_". 

If the ^ character does not exist I would like that cell to be blank. We have written an offset formula but cant help to avoid the dreaded spill. We are hoping to not need a coupling row for each phase item that calls another formula as excel beginners will be using this. 

this is our current code and a screenshot of the file layout 

=OFFSET(INDEX(C$4:AO$4,,MIN(IF(C17:AO17="^",COLUMN(C$4:AO$4)))),0,-2)

thank you so much for your help. 

[#2 · Accepted solution]

@jcontois Not sure why you use OFFSET. The "^" seems to occur only once on a row when it does. Would this one not work for you?

=IFERROR(INDEX($C$4:$AO$4,,MATCH("^",C17:AO17,0)),"")

[#3]

@Riny_van_Eekelen Bless you. thank you so much!