Forum Discussion

b2boop's avatar
b2boop
Copper Contributor
Nov 19, 2018

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

Resources