INDEX MATCH Lookup - Free Excel Practice Online

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

1. What would =INDEX(A1:C5, 5, 3) return?
2. What would =MATCH("Delaware", A:A, 0) return?
3. INDEX and MATCH can be combined for a more flexible lookup than VLOOKUP. What would =INDEX(A:B, MATCH("Arizona", A:A, 0), 2) return?
4. For added flexibility, we can use MATCH for both the row and column argument in INDEX. This way if we add columns, the formula still returns the intended value. What would =INDEX(A:C, MATCH("Alaska", A:A, 0), MATCH("Capital", A1:G1, 0)) return?
5. What would =INDEX(A:C, MATCH("California", A:A, 0), MATCH("Est.", A1:G1, 0)) return?
6. What would =INDEX(A:C, MATCH("Alaska", A:A, 0), MATCH("Est.", A1:G1, 0)) return?
7. What would =INDEX(A:C, MATCH("aRIzONa", A:A, 0), MATCH("CApITaL", A1:G1, 0)) return?
8. What would =INDEX(A:C, MATCH("California", A:A, 0), MATCH("Capital", A1:G1, 0)) return?
9. What would =INDEX(A:C, MATCH("Alaska", A:A, 0), MATCH("Est.", A1:G1, 0)) return?
10. Write the second argument to find the Capital of Delaware: =INDEX(A:C, ???, MATCH("Capital", A1:G1, 0)) (remember, you don't need the = sign!).

INDEX MATCH Lookup practice - FAQ