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 | | |
