Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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?