Not sure if yours work in an array, but I have been using this to mimic an arrayformula experience. Hope it helps.