On Apr 29, 11:55*am, "Mike Fogleman" wrote:
Why VLookup? Why not SUM. VLookup needs three arguments, where are they
located?

Mike wrote in message

...



Hi,

I have a row of 5 values. The sum of the 5 need to be put into another
worksheet using the VLOOKUP function. Does anyone know how to do this?

Thanks.- Hide quoted text -

- Show quoted text -

ah, because my manager doesn;t want the total (sum) to appear on the
first sheet, he only want it on the second sheet which is why I need a
formulae which will both do a SUM calculation and a VLOOKUP (if
necessary)