Microsoft Office Tutorials and References
In Depth Information
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
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.
when they use a number of sheets