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:

Everyday Life

The routine daily activities and experiences of individuals or groups in a society.

Differential Association

A theory in criminology suggesting that individuals learn criminal behavior through their social interactions and communication with others.

Labeling Theory

A theory in sociology that suggests the labels or classifications society applies to individuals can influence their behavior and self-identity.

Control Theories

Theories in criminology and sociology that explain social order and the lack of criminal behavior as a result of societal norms and relationships that encourage conformity.