MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulling team's info by a supervisor's name

Posted by W. Foister on November 06, 2000 5:53 PM

Is there a way to use a supervisor's name in a column to pull all of the information and statistics for a team? I know you can use a similar function to find information on the same row when you locate an ID number.

Posted by Celia on November 07, 2000 3:31 AM

Have a look at VLOOKUP, INDEX/MATCH, etc. in on-line Help.
If this doesn't do it, you will need to post more details.