TransWikia.com

Array formula-ing this formula breaks it...any ideas why?

Web Applications Asked by allison on February 23, 2021

I have a spreadsheet with SheetA and SheetB. I’m trying to pull into SheetA some of the columns of each row in SheetB where the date in Column I of SheetB is earlier than today.

This formula on a single row works:

=IF(SheetB!I2<=TODAY(),{SheetB!B2,SheetB!F2,SheetB!D2,...},"")

But if I try to make it an array formula and apply it to a range, it stops working. E.g.,:

=ARRAYFORMULA(IF(SheetB!I2:I10<=TODAY(),{SheetB!B2:B10,SheetB!F2:F10,SheetB!D2:D10,...},"")

The way it stops working is it seems to no longer care about the <=TODAY part and starts to pull in rows seemingly at random—rows where the cell value in ‘I’ is blank, where it’s a date greater than today, etc.

Any ideas what I’m doing wrong?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP