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

II. Formulas and Functions > 11. Lookup, Reference, and Information Functions

Chapter 11. Lookup, Reference, and Information Functions

Excel’s lookup, reference, and information functions are quite a bit different than the mathematical functions discussed in the last few chapters. Most math functions take your data as a starting point and use it to calculate some new result. Lookup, reference, and information functions, on the other hand, don’t generate any new data. Instead, they let you search for and extract important bits of content from your worksheet and then reuse it in ways guaranteed to delight spreadsheet lovers worldwide.

All three types of functions play different but complementary roles. A lookup function finds and then copies data from a particular cell in a worksheet. A reference function retrieves more general information about groups of cells (like how many columns’ worth of data is in your table). It’s common to use lookup and reference functions together. You might use a reference function to find out which cell has the data you want to use, and a lookup function to actually retrieve the cell’s contents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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