I have spent the past day looking for the correct arrayformula for a formula which works when copying it in the cell, but I would like to have an arrayformula instead. this is my formula I copy in each cell where I want the find the value: =IFERROR(INDEX(SORTN(FILTER(Cart!A$2:C, Cart!B$2:B > C3, C…

After a while @Clement_YEROCHEWSKI I think this would be very hard to achieve with an ARRAYFORMULA setup, so I would recommend you to setup a script that triggers the copy down. I have written about it in the post Nathanael linked. If you need help about that feel free to message me.

Looking for an ARRAYFORMULA

Ask for Help

nathanaelb June 4, 2020, 9:17am 7

Here is a post written by @ThinhDinh

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

2 Likes

Topic		Replies	Views
ARRAYFORMULA, VLOOKUP, QUERY and AND together Ask for Help	13	487	May 29, 2023
Arrayformula Vlookup vs Index Match Ask for Help	6	2007	February 25, 2024
If A1 is present in column B, get C. How do I make it? Ask for Help	22	991	January 17, 2024
Looking for advanced google sheet formulas Ask for Help	15	1344	March 12, 2020
Array Formula Question Ask for Help	6	223	March 15, 2021

Looking for an ARRAYFORMULA

Related Topics