catecumper
New Member
- Joined
- Feb 20, 2019
- Messages
- 2
Hi all,
Long time user, 1st time poster
I have about 700 lines of salary to move into three separate columns (C3, C4, C5) on the right, some of the employee numbers are in the column A more than once, depending on the different rates of pay they get and to do this manually is painful. There must be a formula to say that if employee number 101 (A3) has a salary (B3), then add B3 to column C3 or C4 or C5 depending on which department they work in. I have a separate table with what employee numbers are in each dept, and have tried Vlookup and IF, but when i copy the formula down it doesn't work
<tbody>
</tbody>
all help gratefully received.
Long time user, 1st time poster
I have about 700 lines of salary to move into three separate columns (C3, C4, C5) on the right, some of the employee numbers are in the column A more than once, depending on the different rates of pay they get and to do this manually is painful. There must be a formula to say that if employee number 101 (A3) has a salary (B3), then add B3 to column C3 or C4 or C5 depending on which department they work in. I have a separate table with what employee numbers are in each dept, and have tried Vlookup and IF, but when i copy the formula down it doesn't work
emp no | salary | Dept1 | Dept2 | Det3 |
101 | 1000 | 1000 | ||
102 | 1000 | 1000 | ||
103 | 1000 | 1000 | ||
104 | 1000 | 1000 | ||
101 | 300 | 300 | ||
102 | 50 | 50 | ||
<tbody>
</tbody>
all help gratefully received.