Chapter 9Using Powerful Functions: Logical, Lookup, and Database Functions

Examples of Logical Functions

Examples of Information Functions

Examples of Lookup and Reference Functions

Examples of Database Functions

Examples of Linked Data Types

This chapter covers four groups of workhorse functions. If you process spreadsheets of medium complexity, you turn to logical and lookup functions regularly.

  • The logical functions, including the ubiquitous IF function, help make decisions.

  • The information functions might be less important than they once were because Microsoft has added the IFERROR function, but INFO, CELL, and TYPE still come in handy. The lookup functions include the powerful VLOOKUP, MATCH, and INDIRECT functions. These functions are ...

Get Microsoft Excel 2019 Inside Out 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