Skip to content

Lookup Workout Routine

Let's get this workout started!
What is it?
Lookup() - Matching to a table. Great for recovering Excel folks!
Screen Shot 2021-04-19 at 1.36.53 PM.png
=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.
Screen Shot 2021-04-19 at 1.35.52 PM.png

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
0
Search
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
2
Goal 2️⃣
Why Objective #2 is important!
3
Goal 3️⃣
Why Objective #3 is important!
4
Goal 4️⃣
THIS IS REALLY IMPORTANT
There are no rows in this table

Milestones
1
Search
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
3
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Goal 4️⃣
Milestone 5
00
2


Reveal answer

Goals Answer
0
Search
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
MIlestone #56
Milestone #2
2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
3
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table


Milestones Answer
1
Search
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
5
MIlestone #56
00
10
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 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
0
Search
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
2
Goal 2️⃣
Why Objective #2 is important!
3
Goal 3️⃣
Why Objective #3 is important!
There are no rows in this table

Milestones - Exercise 2
1
Search
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8

Reveal answer

Search
Goal
Description
Related Milestones
1
Goal 1️⃣
Why Objective #1 is important!
Milestone #1
Milestone #2
2
Goal 2️⃣
Why Objective #2 is important!
Milestone #3
Milestone #4
3
Goal 3️⃣
Why Objective #3 is important!
Milestone #5
There are no rows in this table


Milestones - Exercise 2 2
1
Search
Goal
Key Result
Score
Goal 1️⃣
Milestone #1
00
7
Milestone #2
00
1
Goal 2️⃣
Milestone #3
00
1
Milestone #4
00
2
Goal 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
0
Search
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table

Milestones 2
1
Search
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8

Reveal Answer

Search
Goal
Milestone
Update
1
Goal 1️⃣
Milestone #1
2
Goal 2️⃣
Milestone #4
3
Goal 3️⃣
There are no rows in this table


Search
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8
Milestone #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
0
Search
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table

Milestones - Exercise 4
1
Search
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8

Reveal Answer

Goals - Exercise 4 2
0
Search
Goal
Milestone
Update
1
Goal 1️⃣
2
Goal 2️⃣
3
Goal 3️⃣
There are no rows in this table


Milestones - Exercise 4 2
1
Search
Goal
Milestone
Score
Goal 1️⃣
Milestone #1
00
4
Milestone #2
00
5
Goal 2️⃣
Milestone #3
00
9
Milestone #4
00
6
Goal 3️⃣
Milestone #5
00
8



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.