crazybuckeyeguy
New Member
- Joined
- Apr 15, 2017
- Messages
- 49
I could use some help with a V Lookup. The first sheet is a list of names in column 1 in columns 2-5 those are weeks in the year based on the second sheet. Said person can select any of the 52 weeks and up to 4 different weeks. I am working a vacation bid where people select which week they want off for the following year. This would be the case for about 400 people. on the second sheet is a master that would have the weeks in columns and I need to transfer the names to said week but only take 1 spot per week. Each week is only allowed so many names tho. I would need an error returned that the week is full and no more spots are available. I am struggling with the Vlookup and not filling every cell with 1 persons name for the week they choose. PLEASE HELP as I am in dire need. If this doesn't make sense please let me know and I will try to explain more.
<tbody>
</tbody>
<tbody>
</tbody>
Name | Week1 | Week2 | Week3 | Week4 |
Name1 | 1 | 2 | 7 | 0 |
Name 2 | 3 | 6 | 0 | 0 |
Name 3 | 1 | 2 | 3 | 4 |
Name 4 | 2 | 4 | 6 | 7 |
<tbody>
</tbody>
Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week6 | Week 7 |
Name1 | Name 1 | Name2 | Name3 | Name2 | Name1 | |
Name3 | Name3 | Name3 | Name4 | Name4 | Name4 | |
Name4 | ||||||
<tbody>
</tbody>