MATCH Function - Free Excel Practice Online

This free, interactive exercise teaches you MATCH Function 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 MATCH Function 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 MATCH Function lesson

1. The MATCH function searches a range for a lookup value and returns its position in the range. Try typing =MATCH(15, A1:A6, 0) to return 5.
2. What would =MATCH("Banana", A1:A5, 0) return?
3. When the third argument is 0, MATCH looks for an exact match. When it is 1 and the values are sorted in ascending order, MATCH looks for the position of a largest value less than or equal to the match value. what does =MATCH(120, A1:A5, 1) return?
4. When the third argument is -1 and the values are sorted in descending order, MATCH looks for the smallest value that is greater than or equal to the match value. What would =MATCH(405, A1:A5, -1) return?
5. MATCH also supports wildcard matching, where the * symbol can substitute for any text. What would =MATCH("*stin", A:A, 0) return?
6. Write a MATCH function that would return 5.
7. What would =MATCH("M*", A:A, 0) return?
8. What would =MATCH(10, B1:B5, 1) return?
9. What would =MATCH(9, A1:A5, -1) return?
10. Write a match function to get the position of 3 in column A.

MATCH Function practice - FAQ