
Originally Posted by
chuckf201
This is great, however, I have two types of events, daily and weekly. You spreadsheet works great for daily but I'm having trouble with weekly.
I expanded the calendar by adding another row above Day of week. Some events only happen, for example of Tuesdays, every Tuesday.
Can you help?
Problem solved:
=IF(ISNA(MATCH(D$10&"_"&$A2,Activities!$A:$A,0)),"",INDEX(Activities!$C:$C,MATCH(D$10&"_"&$A2,Activities!$A:$A,0)))
Bookmarks