beginner

What is the main purpose of a lookup function in Excel?

A lookup function helps find and connect related data from different tables or lists by matching a key value.

Click to reveal answer

beginner

How does VLOOKUP connect related data?

VLOOKUP searches for a value in the first column of a table and returns a related value from the same row in another column.

Click to reveal answer

beginner

Why is it important to have a unique key when using lookup functions?

A unique key ensures the lookup finds the correct matching data without confusion or errors.

Click to reveal answer

beginner

What happens if a lookup function does not find a matching value?

It usually returns an error like #N/A, meaning no related data was found for the lookup value.

Click to reveal answer

beginner

Give a real-life example of why lookups are useful.

For example, a store can use lookups to find a product price by entering the product ID, connecting the ID to the price list.

Click to reveal answer

What does a lookup function do in Excel?

ADeletes duplicate rows

BAdds numbers in a column

CFinds related data by matching a key

DFormats cells automatically

Which column does VLOOKUP search in to find the matching value?

ALast column

BFirst column

CMiddle column

DAny column

Why should the lookup key be unique?

ATo sort data alphabetically

BTo speed up calculations

CTo make the sheet colorful

DTo avoid errors and find the correct match

What error appears if a lookup value is not found?

A#N/A

B#REF!

C#VALUE!

D#DIV/0!

Which of these is a common use of lookups?

AFinding product prices by product ID

BChanging font size

CCreating charts

DSorting data alphabetically

Explain in your own words why lookup functions are useful for connecting related data in Excel.

Describe what happens when a lookup function cannot find a matching value and why having a unique key matters.