Rank | Job Assigned to | Worker ID | JOB1 | JOB2 | JOB3 |
(insert formula here) | 1 | 4 | 3 | 1 | 5 |
1 | 10 | 3 | 6 | 6 | |
2 | 11 | 1 | 2 | 1 | |
3 | 12 | 2 | 1 | 9 |
Trying to use a Vlookup formula display the number below the job the worker is assigned to in the Rank column. For example in the first row, we see that the worker ID is 4 and they are assigned to Job 1 which is JOB1 in column D. So in A2 the formula would display the number 3. This formula would be carried down throughout column A.