Mr.
Aneke Chimezie
Teacher: Mr. Aneke
Topic:
Using The Lookup
Function
Teacher: Mr. Aneke
Look
upTeacher: Mr. Aneke
Learning Objectives Key Words
• By the end of this class • Lookup
• I should be able to state the function of lookups in vector
excel • Result Vector
• I should be able to identify the different parts of • Lookup
the lookup function value
• I should be able to create a table and search box • Table Array
using the lookup function • Range
• Index
(We will reference page 459-460 of your textbook)
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Starter
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Activity
The lookup function has three major
variations and they are:
Lookup
Vlookup
Hlookup
(Xlookup is also a new variation added to the syllabus only available to
recent Microsoft Office suit)
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Activity
• Find out what they mean and differentiate between
the 3 lookups using a table on Google Docs (eg)
1st objective: state the function of lookups in excel
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Activity
• Find out the different parts that make up the
lookup function and state what they do (group
activity) place your findings on google docs
2nd objective: identify the different parts of the lookup function
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Individual Task
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Guide
• A demonstration of how Lookup works
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Task 2
• Create this table on excel
3rd Objective: to create a table and search box using the Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Guide
Functions
• Work with the teachers example
3rd objective: to create a table and search box using the lookup function
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Individual Task
Teacher: Mr. Aneke
Topic: Using Lookup Thur:27th May
2024
Functions
Quick Review quiz
• [Link]
11001ef4a22d/lookup-functions?fromSearch=
true&source=
• Steps guide link and Note
• [Link]
251-369d5e3864cb
Plenary
Teacher: Mr. Aneke