How to Use VLOOKUP in Google Sheets - Beginner's Tutorial

Offered By: Teacher's Tech via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Learn how to use VLOOKUP in Google Sheets with this beginner-friendly 13-minute tutorial. Discover the power of this data matching tool through step-by-step examples, including using different search keys, column indexes, and handling approximate vs. exact matches. Explore real-world applications, error value replacement, and working with multiple criteria. Follow along with the provided practice spreadsheet to gain confidence in using VLOOKUP for efficient data organization and comparison in your own projects.

Syllabus

Introduction
Using different search keys in VLOOKUP
Using different column indexes
Approximate match vs exact match
Replace error value in VLOOKUP
VLOOKUP with multiple criteria

Taught by

Teacher's Tech

Related Courses

Making Sense of Data
Google via Independent Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn Digital Media Analytics: Introduction
Purdue University via FutureLearn