"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.