Bob,

only part of my earlier answer was repeated in this post. F2 was the
cell containing the formula, so this needed to be selected and then
the fill handle could be double-clicked.

Pete

On Jul 24, 10:10*am, "Bob Phillips" wrote:
"vlook fomula" wrote in message

...

and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

You don't need F2 to select the fill handle, at least I never have.