Question 1 of 5
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Product | Q1 | Q2 | Q3 | Q4 | Lookup | |
| 2 | Apple | 10 | 20 | 30 | 40 | Banana | |
| 3 | Banana | 15 | 25 | 35 | 45 | Q4 | |
| 4 | Cherry | 12 | 22 | 32 | 42 | ||
| 5 | Date | 18 | 28 | 38 | 48 |
Two-Way Lookup - Free Excel Practice Online
This free, interactive exercise teaches you Two-Way Lookup in Excel through 5 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 Two-Way 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 Two-Way Lookup lesson
- A two-way lookup finds a value where a row and a column meet. First find the row. Type =MATCH("Cherry", A2:A5, 0) in G5 to get Cherry's position in the product list. - MATCH returns a position, not a value. Cherry is the 3rd product in A2:A5, so it returns 3. The 0 asks for an exact match.
- Now find the column the same way. Type =MATCH("Q3", B1:E1, 0) in G6 to get Q3's position across the header row. - The same function works across a row. Q3 is the 3rd heading in B1:E1, so it returns 3. Note the range starts at B1, so the count starts at Q1.
- INDEX takes a grid, a row number and a column number. Type =INDEX(B2:E5, 3, 3) in G7 to read the 3rd row and 3rd column of the numbers. - B2:E5 is the block of numbers on its own, without the labels. Its 3rd row is Cherry and its 3rd column is Q3, which is 32.
- Now put them together. Replace both numbers with a MATCH: type =INDEX(B2:E5, MATCH("Cherry", A2:A5, 0), MATCH("Q3", B1:E1, 0)) in G8. - This is the two-way lookup. One MATCH finds the row, the other finds the column, and INDEX reads where they cross. It still returns 32, but nothing is hard-coded now.
- Point it at cells instead of typed text so it updates on its own. G2 holds the product and G3 the quarter. Type =INDEX(B2:E5, MATCH(G2, A2:A5, 0), MATCH(G3, B1:E1, 0)) in G9. - With the lookup values in cells, changing G2 or G3 changes the answer without touching the formula. Banana in Q4 is 45.
Two-Way Lookup practice - FAQ
How do I practice Two-Way Lookup in Excel?
Open this free LogicExcel exercise and work through 5 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 Two-Way Lookup 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 Two-Way Lookup lesson?
This lesson covers Two-Way Lookup 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.