vlookup question


N

nejohnso76

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!
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top