Dynamic Calendar Help

[JoeyA1121]

I am trying to create a running production calendar which will take the data of all the jobs we have in house and display them on said calendar. This is the formula I have created so far;

=IFERROR(INDEX('BP Jobs'!$E:$E,MATCH(Calendar!F20, 'BP Jobs'!$Q:$Q,0),1),"")

It works great, however, if there are multiple jobs due on the same date it doesn't display those on the calendar. Only the first job in-line. Is there something I can add to the formula to have it display all the jobs due on a certain day?

Thanks in advance for your help.

[#2 · Accepted solution]

@JoeyA1121 

Do you have Microsoft 365 or Office 2021? If so, you can use

=TEXTJOIN(CHAR(10), "" FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20, ""))

Turn on Wrap Text for the cells with the formula, and make sue that the row height is sufficient to display multiple jobs.

[#3]

Simply, how about this?
=IFERROR(FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20),"")

[#4]

Thank you!! This worked perfectly! Happy Holidays!