Chandoo

Chandoo gave you 1 free month of Skillshare

Take Chandoo 's class and explore thousands more hands-on classes taught by creative experts from around the world.

Get 1 free month of Skillshare

By signing up you agree to Skillshare's Terms of Service and Privacy Policy, and agree to receive marketing communications from Skillshare at the email address provided. This page is protected by reCAPTCHA and is subject to Google's Terms of Service and Privacy Policy.

Chandoo ’s Class on Skillshare

Master Excel Lookup Functions for Data Analysis

1h 7m (12 lessons)

2,769 students

Class Certificate upon completion

Downloadable Resources available

Take this class today!

  • 1.
    Welcome to the Lookups Course
    2:34
  • 2.
    Basics of VLOOKUP, XLOOKUP and HLOOKUP
    11:50
  • 3.
    The INDEX+MATCH formula
    3:34
  • 4.
    Two way lookups (Row & Column)
    6:11
  • 5.
    All matching results with Lookups
    8:54
  • 6.
    Lookups on Derived Columns
    5:52

1h 7m (12 lessons)

2,769 students

Class Certificate upon completion

Downloadable Resources available

Take this class today!

Join the global creative community of 600K+ members

Creative Learning Made Easy

Countless Classes

Thousands of creative classes. Beginner to pro.

Premium Content

Original and community classes curated for you.

Certificates

Earn rewards to celebrate your accomplishments.

All memberships will be billed automatically on a recurring basis until cancelled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.