I am trying to get an ARRAYFORMULA
to check column A for today's date, then display a 9-row table, but because the array continues, it only shows the first row. Is there any way to move the data over so as not to interfere with the array or stop the array after it finds today's date?
=ARRAYFORMULA(IF(A721:A=TODAY(),ARRAYFORMULA($T$12:$Y$20),))
I tried using {"",ARRAYFORMULA($T$12:$Y$20}
, but that only allows for one row.
Use vstack()
, like this:
=let(
range, T12:Y20,
offset, xmatch(today(), A721:A) - 1,
filler, iferror(
makearray(offset, columns(range),
lambda(r, c, iferror(ø))
),
tocol(æ, 2)
),
if(iserror(offset),
iferror(ø),
vstack(
filler,
range
)
)
)
The formula should go to row 721
in a free column that has an additional five free columns on the right so that there is room for the results the array formula returns.
See let(), xmatch(), iferror(), makearray(), tocol() and vstack().