I want to be able to multiply a single cell with a range of cells (could be an array constant) and have the result populate a new range which corresponds to the positions of the individual elements of the original range. The easy way to do this would be to copy the range into the cells above the new range and just do a simple multiplication formula. The problem is that I need to do this many many times and I would like to just use a named range or an array constant from a constants tab.

Essentially I want this without having to have the row of factors at the top.

factor1 factor2 factor3 factor4 factor5
DATA result1 result2 result3 result 4 result 5

Your suggestions would be extremely helpful.