I must find the monstrous function which indexes virtual arrays that I implemented in a Google sheet of mine when I discovered there’s no limit to how reckless you can be in a single cell.
Edit: Here it is:
ARRAYFORMULA(IFERROR((INDEX('InvoiceHistory'!$A$7:$A$44, SMALL(IF(($G$3='InvoiceHistory'!$D$7:$D$44)*('InvoiceHistory'!$F$7:$F$44="Unpaid"), MATCH(ROW('InvoiceHistory'!$A$7:$A$44), ROW('InvoiceHistory'!$A$7:$A$44)), ""), ROW(A1))))))
According to my documentation, it is used for “Looking up a value on a row, on another sheet, where two other values on that row match the given criteria”
I must find the monstrous function which indexes virtual arrays that I implemented in a Google sheet of mine when I discovered there’s no limit to how reckless you can be in a single cell.
Edit: Here it is:
ARRAYFORMULA(IFERROR((INDEX('Invoice History'!$A$7:$A$44, SMALL(IF(($G$3='Invoice History'!$D$7:$D$44)*('Invoice History'!$F$7:$F$44="Unpaid"), MATCH(ROW('Invoice History'!$A$7:$A$44), ROW('Invoice History'!$A$7:$A$44)), ""), ROW(A1))))))According to my documentation, it is used for “Looking up a value on a row, on another sheet, where two other values on that row match the given criteria”