Explain the Different Lookup Functions in Excel

question 1

Essay

Explain the different Lookup functions in Excel.

---

Definitions:

Retailers

Businesses that sell goods directly to consumers.

Price Floor

A government-imposed minimum price set above the equilibrium price, intended to ensure fair conditions for producers.

Minimum Price

A price floor set by the government or a body, below which the product cannot be sold, aimed at protecting producers or farmers.

Government

is the system or group of people governing an organized community, often a state, which creates and enforces laws, regulates economic and social policies, and provides public services.