can't seem to find your non-working formula anywhere. I need to see your edits to see where it is breaking.

Also, Array formulas are confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will see enclosing braces { } appear around your formula to indicate an active array. Maybe that's all you missed.