Lookup functions. Here is the problem again: The file named Employees.xlsx contains the rating (on a 010

Question:

“Lookup functions.” Here is the problem again: The file named Employees.xlsx contains the rating (on a 0–10 scale) that each of 35 workers has given to three jobs. The file also gives the job to which each worker is assigned. Use a formula to compute each worker’s ranking for the job to which the worker is assigned.