Lookup functions in Excel 2016

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?

Read the chapter here.

Skip to main content