• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Working with Lookup Functions > Understanding Lookup Tables

Understanding Lookup Tables

The table—more properly referred to as a lookup table—is the key to performing lookup operations in Excel. The most straightforward lookup table structure is one that consists of two columns (or two rows):

  • Lookup column— This column contains the values that you look up. For example, if you were constructing a lookup table for a dictionary, this column would contain the words.

  • Data column— This column contains the data associated with each lookup value. In the dictionary example, this column would contain the definitions.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint