The file named Assign.xlsx gives the assignment of workers to four groups. The suitability of each worker for each group (on a scale from 0 to 10) is also given. Write a formula that gives the suitability of each worker for the group to which the worker is assigned.

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 69 70 71 72 73 74 75 76 77 78 79 80 81 82 A Assigned 4 1 3 1 2 3 1 3 1 4 3 2 1 4 3 1 1 2 3 2 3 4 3 3 1 3 2 2 2 2 4 4 4 1 4 3 1 1 2 1 3 2 4 1 2 2 4 B Worker 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 68 69 70 71 72 73 74 75 76 77 78 79 80 C 1 9 10 5 4 9 5 8 2 8 7 8 0 9 9 1 9 8 6 3 3 1 5 8 3 7 0 3 2 1 2 3 1 5 8 4 4 9 3 2 2 5 5 9 2 7 2 0 D 2 8 0 8 0 10 2 3 2 7 0 1 7 0 2 3 6 0 7 4 9 6 1 7 6 1 9 9 4 6 3 5 1 1 2 3 4 0 4 9 2 8 9 9 0 8 4 0 E 3 6 5 10 5 4 7 1 9 6 1 6 1 5 2 8 4 5 6 5 4 9 3 10 4 1 8 1 0 7 3 4 3 2 3 1 7 3 2 9 1 10 1 2 0 6 2 2 F 4 8 6 5 2 5 3 2 2 3 8 6 2 4 7 4 5 0 3 4 4 1 7 2 4 0 1 5 1 3 0 8 7 6 3 7 2 4 2 7 2 0 2 7 0 5 3 7 G Quality F