Do you know array formulas (which it is)?

If not, please observe that when entering or editing such a formula you most hold down Ctrl and Shift before pressing Enter. When you have entered one array formula you can copy it to other cells in normal ways. If you do it correctly Excel will automatically put braces around the formula.