Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Intermediate Spreadsheets!
You have completed Intermediate Spreadsheets!
Preview
In this video, we'll introduce you to lookup functions to find specific data points within a table.
Resources
Two different types of lookups:
- VLOOKUP - the V in VLOOKUP stands for "vertical"; it will search and find in a column, up and down.
- HLOOKUP - the H in HLOOKUP stands for "horizontal", it will search and find in a row, left and right.
When data is organized in columns, you'll typically use a VLOOKUP to search up and down.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
First things first, make sure you have
a copy of the Google Sheets workbook found
0:00
in the Teacher's Notes.
0:03
Open it in a browser on your computer
to follow along with me if you wish.
0:05
Notice the tabs along the bottom,
0:09
these are the individual worksheets
we will use throughout the workshop.
0:10
I'll let you know which ones
you'll need for each video.
0:15
For this video, we'll use the first
worksheet titled Texas Rental Data.
0:18
It contains rental data and the population
for every county in the state of Texas.
0:23
Did you know there were
254 counties in Texas?
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up