In this chapter from Microsoft Excel Data Analysis and Business Modeling, 5th Edition, author Wayne Winston discusses the syntax of lookup functions in Microsoft Excel 2016.
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?