Here was the original formula:
=IFERROR(INDEX(tblEvents,SMALL(IF(Dates=F$14,ROW(Dates)),ROW(1:1))-TableRowStart,4),"")
I created a 2013 calendar, each sheet is one month, my front sheet are a list of activities that references dates throughout the year. I originally got the above from an ms office template for event planning. Although the template did what I wanted it was very limited so I created my own.
What I need:
I need a formula that when I am on the January 2013 sheet on Jan first, it will pull an array from tblevents (my date and events for that date table) and the cell will show the activity on the calendar (Happy New Year). Now I need a formula the can reference multiple activities on one day and on days with no activities it is left blank. Now the above formula does that but will not show the activity in the cell. if I use the created template as is its works, however if you double click on the cell in the calendar the activity disappears and will not return. I posted screenshot to google docs with formulas to assist.
Vlookup works but does not leave cells blank with out N/A if it has nothing to reference and will not do multiple activities on one day![]()
This will take you to a google doc to show images:
https://docs.google.com/document/d/1...it?usp=sharing
Bookmarks