Question 1 of 10
=MATCH("Fiji", A:A, 0)
The final 0 in the formula just tells Excel that we're looking for an exact match. Enter the resulting position number into the field below to check your answer.
INDEX MATCH Practice - Free Excel Practice Online
This free, interactive exercise teaches you INDEX MATCH Practice in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Index Match Lookup track and works right in your browser - no Excel install, no download, and no signup.
Practising INDEX MATCH Practice this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this INDEX MATCH Practice lesson
- The MATCH function finds the position of a value in a range of cells. To find the position of Fiji in column A, click into cell F2 and enter the following formula:=MATCH("Fiji", A:A, 0)The final 0 in the formula just tells Excel that we're looking for an exact match. Enter the resulting position number into the field below to check your answer.
- In cell F3 enter =MATCH("Banana", 1:1, 0) to get the position of the label "Banana" in row 1. Enter the resulting number in the field below.
- The INDEX function returns the value from a cell in a grid, as specified first by the vertical position, then horizontal. To return the number of tonnes of avocados produced by Seychelles, write the following formula into cell F4:=INDEX(A:D, 2, 4)because we're looking in the 2nd row from the top, and the 4th column from the left. What does the formula return?
- Now in your formula in F4, replace 2 with MATCH("Seychelles", A:A, 0) and replace 4 with MATCH("Avocado", 1:1, 0). What does the formula return?
- To find the number of tonnes of Coffee Beans produced by Tonga, simply replace "Seychelles" with "Tonga" and replace "Avocado" with "Coffee Bean". What does the formula return?
- How many tonnes of Bananas did Italy produce?
- How many tonnes of Coffee Beans did Nepal produce?
- How many tonnes of Bananas did Zambia produce?
- How many tonnes of Avocados did Panama produce?
- How many tonnes of Bananas did Bermuda produce?
INDEX MATCH Practice practice - FAQ
How do I practice INDEX MATCH Practice in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the INDEX MATCH Practice exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this INDEX MATCH Practice lesson?
This lesson covers INDEX MATCH Practice as part of the Index Match Lookup track. You practice the syntax step by step until it becomes muscle memory you can use at work.