Library

Course: Excel - VLookup & HLookup

Excel - VLookup & HLookup

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Looking up data is a very useful and powerful tool to have when working in Excel. Unfortunately, there are common myths going around that Lookups are really difficult and only for the super advanced users!

To 'Lookup' something, in a nutshell, means to search a particular value from one spreadsheet or workbook against another particular value that we already know. Think of it like searching for a phone number in a telephone directory.

The VLookup and HLookup functions provide the easiest way to search and locate values from both Columns and Rows. By the end of this course, you'll be able to match customer details to Purchase Orders, retrieve product information from a stock sheet and so much more!

Who is the target audience?

  • All Excel users from Beginner to Advanced
Basic knowledge
  • Students are only required to have a basic understanding of how rows and columns are referenced in Excel
What you will learn
  • What are Lookups, their structure and how they work in Excel
  • How to use Range Names with Lookups
  • Creating a VLookup and HLookup Formula
Curriculum
Lectures quantity: 5
Common duration: 00:33:33
Conquering VLookup and HLookup
  • Introduction  
  • Working with Range Names  
  • Breaking down the VLookup  
  • Creating a VLookup  
  • Creating a HLookup  
reviews (0)
Average rating
0
0 voices
Detailed rating
5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 stars
0%