vlookup and sum

C

CyberFox

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,
 
B

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

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