Lookup Functions Exercise

Here you can find sample files to download for lookup functions exercise.

Function Name: VLOOKUP

What is VLOOKUP?
Lessons for VLOOKUP

1st Exercise: It is a simple table with vegetable name and quantity from where you have to lookup the value using VLOOKUP function.

Download

2nd Exercise: It is a little more complex table with student name and marks in different subject from where you have to lookup the value using VLOOKUP function.

Download

Function Name: HLOOKUP

What is HLOOKUP?
Lessons for HLOOKUP

1st Exercise: It is a simple table with vegetable name and quantity from where you have to lookup the value using HLOOKUP function.

Download

2nd Exercise: It is a little more complex table with student name and marks in different subject from where you have to lookup the value using HLOOKUP function.

Download

Function Name: INDEX

What is INDEX?

Function Name: MATCH

What is MATCH?
How to combine INDEX and MATCH to make the best lookup formula?

Exercise: It is a table with student name and marks in different subject from where you have to lookup the value by making making formula combining INDEX and MATCH functions.

Download