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

Chapter 5. Using Functions in Formulas > The VLOOKUP & HLOOKUP functions

The VLOOKUP & HLOOKUP functions

The VLOOKUP (Figures 71 and 72) and HLOOKUP functions return information based on data stored in a lookup table. The function attempts to match a value in one of its arguments to values in the first column (VLOOKUP) or first row (HLOOKUP) of the lookup table. If it finds a match, it returns the associated value.

Figure 71. This example illustrates the VLOOKUP function. When you enter an item number in cell B1, the formula in B2 attempts to match it to a value in the first column of the lookup table below it (A5:D12) . If it finds a match, it returns the value in the fourth column of the same row as the match. The formula in cell B2 is shown in cell C2.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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