Feb 07 2022 02:43 AM - edited Feb 07 2022 04:41 AM
Hi,
I'm working on a large spreadsheet and hoping to do the following;
Using an employee reference, i would like to generate a number in to a certain cell.
For example (please see below):
If employee number 1 is on that sheet, id like value 2 to equal 10.
If employee number 5 is on that sheet, id like value 2 to equal 20.
Emp Ref | Emp Name | Value 1 | Value 2 |
1 | Smith, A | ||
2 | Smith, B | ||
3 | Smith, C | ||
4 | Smith, D | ||
5 | Smith, E | ||
6 | Smith, F | ||
7 | Smith, G | ||
8 | Smith, H | ||
9 | Smith, I | ||
10 | Smith, J |
Feb 07 2022 04:43 AM