sum with vlookup

  • Thread starter Thread starter Tom Bartolo
  • Start date Start date
T

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
 
Try using INDIRECT to wrap the VLOOKUP, for example:

: =SUM(INDIRECT(VLOOKUP($A6,MyRange,3)):INDIRECT(VLOOKUP($A6,MyRange,4)))
 
Sorry, INDEX was the funtion I needed. It woks perfectly with SUM.
Thanks for the help.

Tom
 
Back
Top