VLOOKUP in Google Sheets - Step by Step
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Wishlisted Wishlist

Please confirm that you want to add VLOOKUP in Google Sheets - Step by Step to your Wishlist.

Add to Wishlist

VLOOKUP in Google Sheets - Step by Step

Learn the VLOOKUP function in Google Sheets though basic and advanced training exercises.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Created by Tim Kope
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create searchable data tables.
  • Understand all the different components of the VLOOKUP function.
  • Apply the VLOOKUP function to search through multiple tables.
View Curriculum
Requirements
  • You should have some familiarity with Google Sheets.
Description

Welcome to VLOOKUP in Google Sheets - Step by Step

Learn one of the most effective functions used to locate data in your Google Sheets tables.

As a new or experienced Google Sheets user, this course will teach you VLOOKUP - a very useful function that will save you time when searching tables.

With this course, you will accomplish the following:

  • Learn what a searchable table is and how to create your own.
  • See how the VLOOKUP function is broken into components and how to utilize each and every component effectively.
  • Create a basic VLOOKUP Google Sheets application.
  • Make your VLOOKUP function interactive to search tables without editing your formula each time.
  • How to use VLOOKUP between two sheets on the same spreadsheet as well as on completely different spreadsheets.
Who is the target audience?
  • This course is for anyone who uses Google Sheets to store or sort information.
  • This course is for professionals who want to reduce paperwork by storing information on Google Sheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Welcome to VLOOKUP for Google Sheets
2 Lectures 02:00

Resources
00:15
+
Getting Started with VLOOKUP
8 Lectures 19:49





Using a Table That is Anywhere on Spreadsheet
03:53

Using a Third Row with VLOOKUP
02:48

SOLVED - How to use Third Row with VLOOKUP
03:35
+
Project 2: How to Use VLOOKUP with Multiple Sheets
9 Lectures 38:08
Start Project 2 and Format Your Spreadsheet
02:11

Add Some Searchable Data
02:39

Add an Invoice Chart
04:42

Draft Our Index Spreadsheet
04:07

Using VLOOKUP Across Different Sheets in a Spreadsheet
04:16

Apply VLOOKUP to get COST and Calculate Payment
05:35

Copy and Alter VLOOKUP to get more Repair Order Information
03:05

Use VLOOKUP to Get Car Information
04:18

Use VLOOKUP to Get Customer Information
07:15
About the Instructor
Tim Kope
0.0 Average rating
0 Reviews
6 Students
3 Courses
Spreadsheet Master

Thank you for visiting my profile!

As a sales enthusiast, I have spent years learning what makes the customer's mind tick. 

i also spent quite a bit of time building very elaborate charts to keep charge of my sales.

I am very interest in teaching you how to build elaborate charts. If you want to learn any aspect of creating a Google Sheets spreadsheet, let me know! I'll create a new video series for you!