Forum Discussion
b2boop
Nov 19, 2018Copper Contributor
Calendar - returning a list based on date
I have expanded on a MS Excel template "Academic Calendar". I have two parts:
LIST: of events (Table format Date -> Events);
Calendar (Monthly) which can change based on year and month view. The dates are based on a formula.
I have named my table and first columns as a named reference in Excel. Based on the formula found using arrays, I am not returning multiple values as expected.
See attached example excel document with 2 sheets.
Highlighted are the examples that I'm trying to create (that is two listings for the 22nd Nov 2018). If I use a vlookup formula, I return a single value to the calendar, however, I would like tor return up to 4 events in a calendar day, hence the use of index arrays.
Appreciate some expert advice.
No RepliesBe the first to reply