Chapter 3. Lookup functions
Questions answered in this chapter:
How do I write a formula to compute tax rates based on income?
Given a product ID, how can I look up the product’s price?
Suppose that a product’s price changes over time. I know the date the product was sold. How can I write a formula to compute the product’s price?
Syntax of the lookup functions
Lookup functions enable you to “look up” values from worksheet ranges. Microsoft Excel ...