vlookup and sum

[Guest]

Hi there,
Is there a way to sum data with a vlookup, as follows:
Style Jan Feb Mar Apr ...
002 100 100 100 100 ...
003 150 150 150 150 ...

In another sheet, I want to sum year-to-date info by style.
sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0)

Thank you and regards,

 

[Bob Phillips]

Why not just do

=SUM(B2:I2)

why do you need the lookup?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Cos I'm compiling financial info, and need to sum based on the month chosen...

 

[Bob Phillips]

You can just use

=SUM(OFFSET(B2,,,1,3))

where 3 is the month number

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)