Using Only the "VLOOKUP" Function, Transfer All of the Data

question 34

Essay

Using only the "VLOOKUP" function, 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 { Ast } & 12 & \text { blue } \\\hline\end{array}$$ ​ $$\begin{array}{l}\text { Individual Sales }\\\begin{array} { | l | l | l | l | } \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}\end{array}$$

---

Definitions:

Marginal Product

The increase in output resulting from a one-unit increase in the amount of a single input used, keeping all other inputs constant.

Premium

A premium is the amount paid for an insurance policy, representing the price for the insurance coverage or the amount over the nominal value of something.

Advanced Degrees

Educational certifications beyond the undergraduate level, including master's, doctoral, and professional degrees.

Median Earnings

The middle value of earnings in a given distribution, where half of the observation points are below and half above.