LOOKUP Functions Exercise
Here you can find sample files to download for the lookup functions exercise.
Download the VLOOKUP function exercise from here.
Function Name: VLOOKUP
What is VLOOKUP?
Lessons for VLOOKUP
1st Exercise: It is a simple table with vegetable names and quantities from which you have to look up the value using the VLOOKUP function.
2nd Exercise: It is a little more complex table with student names and marks in different subjects from where you have to look up the value using the VLOOKUP function.
Download the HLOOKUP function exercise from here.
Function Name: HLOOKUP
What is HLOOKUP?
Lessons for HLOOKUP
1st Exercise: It is a simple table with vegetable names and quantities from which you have to look up the value using the HLOOKUP function.
2nd Exercise: It is a little more complex table with student names and marks in different subjects from where you have to look up the value using the HLOOKUP function.
Download the INDEX-MATCH exercise from here.
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 names and marks in different subjects from which you have to look up the value by making a formula combining INDEX and MATCH functions.