Sequential21
New Member
- Joined
- Mar 12, 2015
- Messages
- 3
I'm working on a data entry spreadsheet.
Basically the process needs to be - Enter Worker's Name in the first column>Manager's name is automatically entered in the second column>Area manager's name is entered in the third
e.g. Joe Smith>David Jones>Mark Johnson
On a separate sheet I've got a list of the names of all of the workers (400 or so) with the managers (around 50) and area managers (10) in separate columns. I need a formula for this first sheet that automatically enters the manager and area manager's names in the adjacent columns when the worker's name is manually entered.
I've attempted using the IF and OR function with no success so far.
Basically the process needs to be - Enter Worker's Name in the first column>Manager's name is automatically entered in the second column>Area manager's name is entered in the third
e.g. Joe Smith>David Jones>Mark Johnson
On a separate sheet I've got a list of the names of all of the workers (400 or so) with the managers (around 50) and area managers (10) in separate columns. I need a formula for this first sheet that automatically enters the manager and area manager's names in the adjacent columns when the worker's name is manually entered.
I've attempted using the IF and OR function with no success so far.
