See here for more explanation:

http://www.cpearson.com/excel/ArrayFormulas.aspx

also Google for "Array Formulas" for even more material.