I have a table (table 1) with objects on the Y-axis and customers on the X-axis.
Table 1 takes data from another table(table 2) were a object can be selected with a customer and a type of event is selected with a start date and eventually a end date, there is a comment section in table 2 as well.

Table 1 is showing the event type when there is no end date given in table 2.
i would like to show this comment as a note/comment in table 1 when an event is active and therefore showing in table 1.

i’m using INDEX/MATCH to make table 1 in a backlog and refer to this in the “front end” excel sheet for layout purposes.

is this possible? i’m having a steep learning curve with excel but this is still out of my league.

I did search stackoverflow and found some similar cases but due to my knowledge regarding functions i could not make this work in my case with different requirements