Forum Discussion
Calendar Help
Basically the same technique as you and SergeiBaklan but with a slightly risky edge that might invite Sergei's comment. I do not normally use VLOOKUP but it seems as good as any alternative here
= IFERROR( TEXTJOIN( ¶, TRUE,
VLOOKUP( Current_Date, Important_Dates, {2,3,4,5,7}, FALSE )
),"")
The main risk is in my definition of 'Current_Date' which I allowed to be relative to the active cell and sheet (immediately above it) by referring to
=!R[-1]C
It seems to be working and allowed me to add an 'important date'. The name '¶' is a little non-standard but it simply refers to the line feed character
=CHAR(10)
The other point of note is that the array constant returns an array of 5 text strings that TEXTJOIN combines (Office 2013 and later I think)