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

Chapter 25. Manipulating and Analyzing D... > Using Formulas to Look Up Data in Ta...

Using Formulas to Look Up Data in Tables

You can build a table in Excel and look up the contents of various cells within the table. Lookup tables provide an efficient way of producing numbers or text that you cannot calculate with a formula. For example, you might not be able to calculate a tax table or commission table. In these cases, looking up values from a table is much easier. Tables also enable you to cross-check typed data against a list of allowable values.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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