Skip to content
Lookup() - Matching to a table. Great for recovering Excel folks!
=VLOOKUP (value, table, col_index, [range_lookup])value - The value to look for in the first column of a table.table - The table from which to retrieve a value.col_index - The column in the table from which to retrieve a value.range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.Filter() - Multidimensional queries.
Reveal answer
Reveal answer
Reveal Answer
Reveal Answer
Lookup Workout Routine
Let's get this workout started!
What is it?
Exercise 1
We have a table of goals, and a table of milestones. We want to pull in all the milestones for each goal into our table and then view them as a subtable. Use the Lookup formula.
Your answer:
Goals
Goal
Description
Related Milestones
Goal 1️⃣
Why Objective #1 is important!
Goal 2️⃣
Why Objective #2 is important!
Goal 3️⃣
Why Objective #3 is important!
Goal 4️⃣
THIS IS REALLY IMPORTANT
There are no rows in this table
Milestones
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
3Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8Goal 4️⃣
Milestone 5
00
2
Goals Answer
Goal
Description
Related Milestones
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
MIlestone #56
Milestone #2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table
Milestones Answer
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
5MIlestone #56
00
10Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8
Exercise 2
We have a table of goals, and a table of milestones. We want to pull in all the milestones for each goal into our table and then view them as a subtable. Use the Filter formula.
Your answer:
Goals - Exercise 2
Goal
Description
Related Milestones
Goal 1️⃣
Why Objective #1 is important!
Goal 2️⃣
Why Objective #2 is important!
Goal 3️⃣
Why Objective #3 is important!
There are no rows in this table
Milestones - Exercise 2
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
4Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8
Goal
Description
Related Milestones
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
Milestone #2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table
Milestones - Exercise 2 2
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
7Milestone #2
00
1Goal 2️⃣
Milestone #3
00
1Milestone #4
00
2Goal 3️⃣
Milestone #5
00
1
Exercise 3
Now, we don’t want to see all related milestones. We want to create a select list that only has the milestones related to the goal in the row. Use the Lookup formula.
Your answer:
Goals 2
Goal
Milestone
Update
Goal 1️⃣
Goal 2️⃣
Goal 3️⃣
There are no rows in this table
Milestones 2
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8
Goal
Milestone
Update
Goal 1️⃣
Milestone #1
Goal 2️⃣
Milestone #4
Goal 3️⃣
There are no rows in this table
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8Milestone #6
00
2
Exercise 4
Now, we don’t want to see all related milestones. We want to create a select list that only has the milestones related to the goal in the row. Use the Filter formula.
Your answer:
Goals - Exercise 4
Goal
Milestone
Update
Goal 1️⃣
Goal 2️⃣
Goal 3️⃣
There are no rows in this table
Milestones - Exercise 4
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8
Goals - Exercise 4 2
Goal
Milestone
Update
Goal 1️⃣
Goal 2️⃣
Goal 3️⃣
There are no rows in this table
Milestones - Exercise 4 2
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4Milestone #2
00
5Goal 2️⃣
Milestone #3
00
9Milestone #4
00
6Goal 3️⃣
Milestone #5
00
8
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.