melodramatic
Board Regular
- Joined
- Apr 28, 2003
- Messages
- 180
- Office Version
- 365
- Platform
- Windows
OK, I copied an Index formula earlier, and finally realized it's not working because my data is in columns, not in row. I think, at least.
I've got two separate tables.
Table #1 (Table Name is "W_B3") is used to schedule personnel to work on projects. Each project will have its own line, and on the day of scheduling, you put in the initials of personnel working that project.
Table #2 (Table Name is "W_Techs") is used to show which personnel are scheduled, and the project/equipment for their schedule on any specific day.
My messed-up formula is intended to work in Table #2, by searching the day column in the B3 table, sarching for the Employee initials, and then put in the cell for the project/equipment. The whole thing is mussed up.
I'm putting in a screen capture of what I'm getting as my answers - and hoping that someone can give me a lesson in how to do it right.
Thank you in advance!!!
I've got two separate tables.
Table #1 (Table Name is "W_B3") is used to schedule personnel to work on projects. Each project will have its own line, and on the day of scheduling, you put in the initials of personnel working that project.
Table #2 (Table Name is "W_Techs") is used to show which personnel are scheduled, and the project/equipment for their schedule on any specific day.
My messed-up formula is intended to work in Table #2, by searching the day column in the B3 table, sarching for the Employee initials, and then put in the cell for the project/equipment. The whole thing is mussed up.
I'm putting in a screen capture of what I'm getting as my answers - and hoping that someone can give me a lesson in how to do it right.
Thank you in advance!!!