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
Course ID Number: MSO-3001