From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Look up a value in a range - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Look up a value in a range
- When you collect data in a Google Sheets Workbook, you can look up values in a list, as long as your data is laid out correctly. In this movie I will show you how to combine Worksheet layout and a formula to look up values in a data range. This Workbook contains a short list of Customer ID's followed by the associated Customer Name and Customer Country. What I'd like to do is to enter in a Customer ID, which might appear on an order form, and be able to look up the Customer Name. To do that, I will use the VLookup function, I click in cell F3 to activate it, and then type an = sign and the function I'll use as you probably guessed is Vlookup. Now, I need to enter in my search key. The search key is the cell that contains the value that I want to look up. So, I'll click cell F2. I don't have a value there yet, but I will soon. Then, a comma, then the range. The range is the set of cells that contains the data that I am going to be using to look up. The Lookup starts with the left…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Count columns and rows in a range1m 56s
-
(Locked)
Select a value given certain inputs3m 19s
-
(Locked)
Look up a value in a range3m 4s
-
(Locked)
Perform advanced lookup operations4m 35s
-
Look up values based on two criteria3m 7s
-
(Locked)
Create a hyperlink in a cell3m 27s
-
(Locked)
Refer to a cell a specified distance from another cell4m 31s
-
(Locked)
-
-