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:

Third Estate

The common people of France prior to the French Revolution, as opposed to the clergy (First Estate) and the nobility (Second Estate).

Natural Resources

Natural resources are raw materials and components found in nature, such as minerals, forests, water, and fertile land, that can be utilized for economic gain and societal development.

Industrialized

Pertains to countries or regions that have developed extensive manufacturing industry as the predominant sector of their economy, typified by technological innovation and large-scale production.

Coal Deposits

Natural accumulations of coal, which is a combustible black or brownish-black sedimentary rock used primarily for electricity generation and steel production.