Vlookup?

[Pete McCosh]

I'm not 100% sure what you're trying to do, if it's just
multiply each group of two figures, then use:

=sumproduct(a1:a4,b1:b4)

Pete

 

[an]

Afirmative!
Many thanks
an

-----Original Message-----
I'm not 100% sure what you're trying to do, if it's just
multiply each group of two figures, then use:

=sumproduct(a1:a4,b1:b4)

Pete
.