In this
lesson, you will learn how to:
1. Create a Lookup Table.
2. Name the Lookup Table.
3. Use a VLookup Table in a Formula.
4. Use an HLookup Table in a Formula
This lesson introduces the Formulas Ribbon.
1.
Formula ->Function Library
->Lookup
& Reference->VLookup, page 118
2.
Formula ->Function Library ->Lookup & Reference->HLookup, page
129
3.
Formula ->Function Library ->Logical ->IF, page 131
4.
Formula ->Function Library ->Logical ->AND, page 133
5.
Formula ->Function Library ->Logical ->OR, page 135
6.
Formula ->Function Library ->Logical ->NOT, page
136
7.
Formula ->Function Library ->Logical ->IFERROR,
page 13 |
|
|
|
