mjswenson84
New Member
- Joined
- Apr 21, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have created a 12 month schedule in Excel. In column A are the different locations. In columns B-M are the individuals. In each B-M column an individual only appears once.
For instance:
In A2 is location alpha. Employee1 appears in B2 (July), employee2 appears in C2 (August), employee3 appears in D2 (September), etc.
In A3 is location beta. Employee3 appears in B3 (July), employee1 appears in C3 (August), employee2 appears in D3 (September), etc.
I now want to create a formula so that I can see where each employee works each month. I need to answer the question "where is employee1 in July, August, September, etc."
So I want a formula to look something like "when employee1 appears in column B, what is the text of column A in that same row"
This is for a large schedule with multiple locations and employees. I need to be able to see an individual employee's schedule for the year to make sure the schedule does not create undo burden on the employee during any given period
For instance:
In A2 is location alpha. Employee1 appears in B2 (July), employee2 appears in C2 (August), employee3 appears in D2 (September), etc.
In A3 is location beta. Employee3 appears in B3 (July), employee1 appears in C3 (August), employee2 appears in D3 (September), etc.
I now want to create a formula so that I can see where each employee works each month. I need to answer the question "where is employee1 in July, August, September, etc."
So I want a formula to look something like "when employee1 appears in column B, what is the text of column A in that same row"
This is for a large schedule with multiple locations and employees. I need to be able to see an individual employee's schedule for the year to make sure the schedule does not create undo burden on the employee during any given period