sum with vlookup

[Tom Bartolo]

I am trying to use the sum function with a vlookup table and it is not
letting me. My formula is:

=sum(vlookup(1,baseline,3):vlookup(1,baseline,month+3))

What am I doing wrong?

Thanks.

Tom

 

[Max]

Try using INDIRECT to wrap the VLOOKUP, for example:

: =SUM(INDIRECT(VLOOKUP($A6,MyRange,3)):INDIRECT(VLOOKUP($A6,MyRange,4)))

 

[Tom Bartolo]

Sorry, INDEX was the funtion I needed. It woks perfectly with SUM.
Thanks for the help.

Tom