Use the worksheet 3-10. The file contains the ranking of each of 35 workers to each of three jobs, job 1, 2 and 3. The file gives the job to which the worker is currently assigned. Use n Lookup function and compute each workers ranking for the job to which he/she is assigned.

Please provide excel formulas used to answer the question. Thank you.

fox L16 H P A 3 Job Number 3 2 Assigned t Worker Bank 2 2 2 3 2 10 6 2 11 3 1 10 3 3 14 E 6 10 15 11 1 16 12 17 1 13 18 14 19 3 15 20 10 5 1 16 21 5 10 17 22 18. 23 3 13 24 5 3 20 25 3 2 10 2 21 26 22 27 10 23 28 3 3 1 24 29 3 25 30 3 26 31 1 27 32 28 33 10 3 23 34 3 3 30 35 3 31 2 36 2 32 37 0 33 3 10 3. 34 39 2 35 40