If the VLOOKUP Function Cannot Find a Match in the Lookup

question 416

Multiple Choice

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

• A) "Match not found" message
• B) #N/A error value
• C) FALSE
• D) #NAME error value

---

Definitions:

Government Subsidy

A financial contribution by a government to a private sector entity for the purpose of lowering the cost of a service or product or supporting a particular activity deemed beneficial.

Demand Curve

A graph showing the relationship between the price of a good and the quantity of the good that consumers are willing to purchase at that price.

Supply Curve

A graphical representation that shows the relationship between the price of a good and the quantity supplied.

Price Ceiling

A government-imposed limit on how high a price is charged for a product or service.