Chapter 3. Lookup functions

Questions answered in this chapter:

Image How do I write a formula to compute tax rates based on income?

Image Given a product ID, how can I look up the product’s price?

Image 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 ...

Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.