When you have a small list of data, such as a phone list or
a price list, it’s easy to scan the list and look up specific information. If
the list is large, the task becomes much more difficult. The VLOOKUP and
HLOOKUP functions help you look up information in an Excel spreadsheet.
Estimated completion time (hours): 1.3
Objectives
By the end of this course, you will be able to do the following
- Explain the purpose of the VLOOKUP and HLOOKUP functions
- Define the terms lookup value and return value
- Describe how data must be arranged for the VLOOKUP and HLOOKUP functions to work correctly
- List the syntax of the VLOOKUP and HLOOKUP functions
- Explain the difference between approximate matches and exact matches when using the VLOOKUP and HLOOKUP functions
Estimated Time (Hrs): 1.5
Language: English