vlookup & subtotals

M

martin

I have a vlookup formula of =VLOOKUP(A2,Sheet1!
$A$7:$K$10157,11,FALSE) & it works nicely BUT sheet 1 is a
list of data that is "subtotals" thru "data" & it is not
picking up these particular figures.

I do not know how to pick these up nor do I know how to
just list the subtotals so that the formula would work.

Any suggestions?
 
D

Dave Peterson

I'm not sure what's in A2, but if you want to retrieve the values in the
subtotal row, then this might work:

When you look at sheet1, you'll see your headers in column A. but on the
subtotal line, they look like:

CustomerNameHere Total

So if A1 contained just the customernamehere, you could do this:
=vlookup(a2&" total", sheet1!$a$7:$k10157,11,false)

You may even want to play around with Data|Pivottables. You can get these
subtotals out pretty easily and then use that for your =vlookup() formulas.
 
Top