I think you're missing my point, but it doesn't really matter.
I'm trying to break down this formula:
=IFERROR(INDEX(Events_Data!$G:$G,MATCH(C4&"_"&$A6,Events_Data!$F:$F,0)),"")
(This is from Paul's version.)
So I can populate with the entries in the array that breaks down the multiple day jobs.
Bookmarks