OS-MSO-3001 Using VLOOKUP and HLOOKUP

Course Description

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.

By the end of this course, you will be able to:

• 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 completion time (hours): 1.3