vlookup question
 

Hi All,
I have a 2 worksheets, 1 of which contains a lot of raw data and the
other is a summary view of the raw data. The raw data is broken down
by week so there are multiple columns per month but the summary
worksheet is summed by month. Is it possible to use a vlookup to find
an item number in a column but specify a range of columns to sum [ex.
=VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,99,FALSE)] instead of just
looking in column 99 I'd like to sum the data in 99 thru 103. Any
suggestions?
Thanks!

vlookup question
 

I know it's a long formula, but looks like the most simple way is to just:
=VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,99,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,100,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,101,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,102,FALSE)+VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,103,FALSE)

-Simon


"nejohnso76" wrote:

Hi All,
I have a 2 worksheets, 1 of which contains a lot of raw data and the
other is a summary view of the raw data. The raw data is broken down
by week so there are multiple columns per month but the summary
worksheet is summed by month. Is it possible to use a vlookup to find
an item number in a column but specify a range of columns to sum [ex.
=VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,99,FALSE)] instead of just
looking in column 99 I'd like to sum the data in 99 thru 103. Any
suggestions?
Thanks!