Part Five
Multi-Page Systems and Lookups
Two topics are discussed in Part Five: multi-page systems and lookup functions.
Most Excel users either keep their entire model or information on one worksheet or—when they use a number of sheets—do not take advantage of structuring the workbook/system so they can use Excel more effectively. The first portion of this part will cover this topic.
The second portion of this part will discuss lookup functions. It will demonstrate how to perform an exact lookup and how to perform range lookups. After you have understood the lookup function described, you will be able to perform any of the other lookup functions.
Get Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd 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.
