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

Hour 15. Using Functions > How to Use Lookup Functions

How to Use Lookup Functions

Lookup functions search for values within tables or lists. Each lookup function uses a different method for searching and returning values. Each method is suited for a particular task. Anytime your worksheet uses tables to hold values, such as tax tables or price tables, you can employ a lookup function for added power in the application.

VLOOKUP and HLOOKUP

These two lookup functions search for values in tables based on a lookup value, the value you are trying to match. For example, a tax table contains tax rates based on income. Income is the lookup value. VLOOKUP searches vertically in a column of values and then returns a corresponding value from the table. HLOOKUP searches horizontally in a row of values and then returns a corresponding value from the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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