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, Cart!A$2:A = A3), 1, 0, 2, TRUE), 3), "")
what I am trying to achieve is to the card_id should be populated with
string from Order:A matches a string in Cart:A
row with date from SORTED(Cart:B, byDate, TRUE) later than date from Order:C
I have made a sample with information and with the expected result using my formula.
If you could help me on finding the properly ARRAYFORMULA, I would really appreciate! it’s killing me.
ps : let me know if you need access to the google spreadsheet.