Try adding the Group column to your Transactions sheet. Seems to have fixed it for me.
Insert column after Account # column and put this equation in that column’s row 1 cell:
={"Group";ARRAYFORMULA(IFERROR(XLOOKUP(INDIRECT("$D2:$D"),INDIRECT("Categories!$A$2:$A"),INDIRECT("Categories!$B$2:$B"))))}
1 Like