Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel - Creating a VLookup and HLookup Formula

Simon Lambourne, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (34m)
    • Introduction to VLookup and HLookup

      2:12
    • Range Names

      6:43
    • VLookup Syntax

      8:53
    • Using VLookup

      9:31
    • Using HLookup

      6:12

About This Class

VLookups and HLookups are very useful formulas used to retrieve information from another set of data. This course will take you through and explain what how a VLookup can work for you and how to set one up. This is a great formula to have at your disposal as many industries rely on using VLookups and HLookups to perform analysis and reporting on data in Excel.

You'll also get to work on the exercise used in the session so you can put into practice what you have learnt!

1

Student

--

Projects

0

Reviews (0)

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 8 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it is important to enjoy attending each training co...

See full profile