How to Use Excel Lookup

Live Online Learning (1 Hour)

This How to Use Excel Lookup introduction will give you the confidence to begin using this key Excel feature.

Through an interactive live online training session, you will be introduced to the world of Excel Lookup. Discover when and where to use them, how they are made, Lookup options available to you and how to search and extract data for specific information.

This How to Use Excel Lookup training session is suitable for users of Excel 2013 and 2016.

What Will I Learn?

How to use Excel Lookup - Understand the purpose and benefits of a Lookup function.

How to choose the right Lookup - There are a variety of lookup functions available; discuss and discover when to use each one.

How to build a Lookup - Understand the structure of a lookup function, and learn to build them.

How to manage Lookup factors and considerations - Understand the factors you must consider when creating Lookups.

How to apply additional Lookup functions - Discover how to choose Lookup options and functions across multiple spreadsheets.


You should have a good understanding of creating and editing workbooks, and using simple formulas and functions in Microsoft Excel 2013 or 2016.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.


£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e:

Course Content

  • What is a Lookup
  • When and how to use a Lookup
  • Which type of Lookup to use
  • Suitable Lookups for different types of searches
  • Understand the building blocks of a Lookup
  • How to identify and use a cell address, a range and an index number to return a value
  • What factors should be considered when creating Lookups
  • How to use a Lookup to find values on another worksheet