Chapter 24. Using Powerful Functions: Logical, Lookup, and Database Functions

In this chapter

Examples of Logical Functions 531

Examples of Information Functions 539

Examples of Lookup and Reference Functions 550

Examples of Database Functions 579

This chapter covers four groups of workhorse functions. If you are processing spreadsheets of medium complexity, you will find yourself turning to logical and lookup functions regularly.

  • The logical functions, including the ubiquitous IF function, help you make decisions.
  • The information functions might be less important than they once were, now that Microsoft has added the IFERROR function, but INFO, CELL, and TYPE still come in handy.
  • The lookup functions include the powerful VLOOKUP, MATCH, and ...

Get Special Edition Using Microsoft® Office Excel® 2007 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