peachycream
New Member
- Joined
- Apr 7, 2011
- Messages
- 44
Can someone assist me with a formula issue I am having please?
I have a cell with a data validation list in it. When I select the name on that list I would like their team to populate in the cells beneath him. The team info is a different worksheet in the same workbook. I thought I could use Vlookup but that doesn't seem to work because it doesn't account for multiple entries under one name. I hope I am describing the issue accurately.
<colgroup><col width="64" style="width: 48pt;" span="4">
<tbody>
</tbody>
I have a cell with a data validation list in it. When I select the name on that list I would like their team to populate in the cells beneath him. The team info is a different worksheet in the same workbook. I thought I could use Vlookup but that doesn't seem to work because it doesn't account for multiple entries under one name. I hope I am describing the issue accurately.
Bob | Sup | Tech | |
Ray | Bob | 1 | |
Tim | Bob | 2 | |
Larry | Bob | 3 | |
Ray | 4 | ||
Ray | 5 | ||
Ray | 6 | ||
Tim | 7 | ||
Tim | 8 | ||
Tim | 9 | ||
Larry | 10 | ||
Larry | 11 | ||
Larry | 12 |