Excel - VLookup & HLookup

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

What are Lookups, their structure and how they work in Excel
How to use Range Names with Lookups
Creating a VLookup and HLookup Formula

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • MS Excel
  • Excel

Course programme

Conquering VLookup and HLookup 5 lectures 33:33 Introduction Working with Range Names Breaking down the VLookup Creating a VLookup Creating a HLookup Conquering VLookup and HLookup 5 lectures 33:33 Introduction Working with Range Names Breaking down the VLookup Creating a VLookup Creating a HLookup Introduction Introduction Introduction Introduction Working with Range Names Working with Range Names Working with Range Names Working with Range Names Breaking down the VLookup Breaking down the VLookup Breaking down the VLookup Breaking down the VLookup Creating a VLookup Creating a VLookup Creating a VLookup Creating a VLookup Creating a HLookup Creating a HLookup Creating a HLookup Creating a HLookup

Additional information

Students are only required to have a basic understanding of how rows and columns are referenced in Excel

Excel - VLookup & HLookup

£ 10 + VAT