SUM a row of data and then use VLOOKUP to paste the total value intoanother worksheet

[nadia.younus]

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.

 

[Bob Phillips]

Why do you need VLOOKUP, SUM would place the value quite nicely on it's own.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[nadia.younus]

Why VLookup? Why not SUM. VLookup needs three arguments, where are they
located?








- 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)

 

[Bob Phillips]

That might make sense to Mike, but it doesn't to me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

Why VLookup? Why not SUM. VLookup needs three arguments, where are they
located?








- 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)