O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9. Using Powerful Functions: Logical, Lookup, Web, and Database Functions

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

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

Image 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required