Using Only "VLOOKUP", Transfer All of the Data from the Table

question 35

Essay

Using only "VLOOKUP", transfer all of the data from the table below into the "Individual Sales" table.
​ $$\begin{array} { | l | l | l | l | } \hline { \text { Individual Sales } } \\\hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 6 & \text { Susan } & 5 & \text { red } \\\hline 8 & \text { Thomas } & 7 & \text { red } \\\hline 9 & \text { Lynn } & 2 & \text { blue } \\\hline 5 & \text { Sean } & 6 & \text { blue } \\\hline 1 & \text { Jerry } & 20 & \text { yellow } \\\hline 2 & \text { George } & 12 & \text { red } \\\hline 10 & \text { Elaine } & 1 & \text { red } \\\hline 7 & \text { Delores } & 4 & \text { blue } \\\hline 4 & \text { Tony } & 9 & \text { yellow } \\\hline 3 & \text { Art } & 12 & \text { blue } \\\hline\end{array}$$ ​ $$\begin{array} { | l | l | l | l | } \hline &{ \text { Individual Sales } } \\\hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 1 & & & \\\hline 2 & & & \\\hline 3 & & & \\\hline 4 & & & \\\hline 5 & & & \\\hline 6 & & & \\\hline 7 & & & \\\hline 8 & & & \\\hline 9 & & & \\\hline 10 & & & \\\hline\end{array}$$

---

Definitions:

Allied Victory

The term often refers to the success of the Allies in World War II, resulting in the defeat of the Axis Powers in 1945.

Wage Caps

Regulations or policies that set a maximum limit on the amount of money that an employee can earn within a specific period.

Skilled Workers

Individuals with specialized training, expertise, or qualifications in a particular profession or craft.

Air Force Service Pilots

A group of civilian women pilots employed to fly military aircraft under the United States Army Air Forces during World War II to free male pilots for combat roles.