Lookup Functions5:20 with Richard Tillies
In this video, we'll introduce you to lookup functions to find specific data points within a table.
Two different types of lookups:
- VLOOKUP - the V in VLOOKUP stands for "vertical"; it will do a search and find in a column, up and down.
- HLOOKUP - the H in HLOOKUP stands for "horizontal", or a 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.
You need to sign up for Treehouse in order to download course files.Sign up