vlookup help please
 

I have multiple pages that have 65,536 rows, same monsterous spreadsheet,
138-MEG and I need to lookup data from each and have a summary sheet accept
the returned answers:

Fleet Removal Date Install Date TSI CSI
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189

I need the return vlookup to get me all of the BMWs, then the Fords, etc.,
and just give me an end result of a count of how many of each, but I need the
TSI and CSI fields to also add up and then average that by the like units:

Fleet TSI CSI
76 BMW 7100:03 5,189
81 Ford 3200:03 3,289
66 Chev 4340:03 389
42 Olds 2180:03 429
21 Suzu 550:03 689
91 Hond 21,100:03 18,189


Can this be done?

Thanks,
Champ

vlookup help please
 

I think it can be done, but I don't understand what you want. Your result
shown at the bottom has as the first column the numbers 76, 81, 66, 42, etc.
What are those? There is no label. Also, how do you add up a "number" like
100:03 and 200:03. What are these #'s? Also your result table shows only
sums, I assume. You want averages too, right? Is each tab (sheet) a
separate summary? And I don't understand what has to be accepted? Please
explain.

"Champ" wrote:

I have multiple pages that have 65,536 rows, same monsterous spreadsheet,
138-MEG and I need to lookup data from each and have a summary sheet accept
the returned answers:

Fleet Removal Date Install Date TSI CSI
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189

I need the return vlookup to get me all of the BMWs, then the Fords, etc.,
and just give me an end result of a count of how many of each, but I need the
TSI and CSI fields to also add up and then average that by the like units:

Fleet TSI CSI
76 BMW 7100:03 5,189
81 Ford 3200:03 3,289
66 Chev 4340:03 389
42 Olds 2180:03 429
21 Suzu 550:03 689
91 Hond 21,100:03 18,189


Can this be done?

Thanks,
Champ