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?

  • How do *, ? , and ~ work with lookup functions?

  • How does Office 365’s powerful XLOOKUP function work?

  • My lookup formulas appear to confuse text and numbers. What can I do?

Syntax of the lookup functions

Lookup functions enable you to look up values from worksheet ranges. Microsoft Excel 365 allows you to perform both vertical lookups (by using the VLOOKUP function) and horizontal lookups (by using the HLOOKUP function). ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.

Start your free trial