Is there a better option to VLOOKUP?

  • Thread starter Thread starter Ter
  • Start date Start date
T

Ter

I have a main spreadsheet that currently uses VLOOKUP to
locate data on 12 (month) separate spreadsheets for 115
different people. There are several variable, such as
name/group/area that are currently included in the
formula. First - is this most efficient way to do this,
if not can you make a recommendation? I will also be
shipping a section of the main spreadsheet out to other
people, and want to avoid the "This workbook contains
links to other data sources" dialogue because they will
not have rights to the data source. I used to be familiar
with writing Macros in Excel 95, but am new to VBA
functions.
All help appreciated. Thanks
Ter
 
Ter,

You're asking the right questions. Need more info about your tables. The
12 month tables -- what are they about? One row per person? Or what?
That's a key thing about a table. The table containing the VLOOKUP --
what's it about? (Same question - one row per what?). With that info, we
can give you some better (maybe even good) advice.

It's likely that your 12 month tables should be combined into one, using a
column to indicate the month. Much functionality is gained by not splitting
data into separate tables.
 
Earl,
Each of the 12 spreadsheets contain 1 large row of monthly
stats for each person - one row per person. The table
containing the VLOOKUP, produces two graphs and a chart
displaying the monthly and cumulative stats for each
person (and two graphs displaying where they stand in
relation to the other people in their group).
And, I see no reason why I couldn't combine all the 12
monthly tables into one.
Thanks for your help.
Ter
 
Back
Top