Conditional reference?

[Guest]

I have an excel spreadsheet that lists the names of all employees along with
their supervisors. I also have another spreadsheet that contains the stats
by day for each associate. This contains many records. What I would like to
do is create a pivot table and be able to pull up the records of all
associates assigned to a particular supervisor. The spreadsheet that
contains the stats by day does not list the supervisor for that employee, and
I have been asked to fix this. How would I go about doing this without
manually referencing each employee to their respective supervisor. Each
employee has about 200 records so it could be quite time consuming.

 

[matt]

I have an excel spreadsheet that lists the names of all employees along with
their supervisors. I also have another spreadsheet that contains the stats
by day for each associate. This contains many records. What I would like to
do is create a pivot table and be able to pull up the records of all
associates assigned to a particular supervisor. The spreadsheet that
contains the stats by day does not list the supervisor for that employee, and
I have been asked to fix this. How would I go about doing this without
manually referencing each employee to their respective supervisor. Each
employee has about 200 records so it could be quite time consuming.

Search Excel for "VLOOKUP" and run through the examples. VLOOKUP will
allow you to look up the supervisor according to the employee name.
Be sure to make the table reference absolute and simply copy the
formula down.

Matt