Excel INDEX Practice Question: Find the value in the last row and last column of the Q1 to Q3 table without…
The question
Find the value in the last row and last column of the Q1 to Q3 table without counting by eye, and put it in F2.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Branch | Q1 | Q2 | Q3 | Corner | |
| 2 | Pune | 40 | 44 | 48 | ? | |
| 3 | Delhi | 52 | 55 | 51 | ||
| 4 | Surat | 33 | 39 | 41 | ||
| 5 | Jaipur | 28 | 31 | 36 | ||
| 6 | Kochi | 25 | 29 | 34 |
The yellow cell is where your answer goes.
Show answer
Answer in F2: 34
How it works
Explanation: ROWS and COLUMNS give the size of the table, which is also the position of its last row and last column.
Syntax: =INDEX(B2:D6,ROWS(B2:D6),COLUMNS(B2:D6))
The table B2:D6 has 5 rows and 3 columns, so INDEX(...,5,3) returns Kochi's Q3: 34.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →INDEX syntax
Returns the value at a given row/column position within a range. Pulling the Nth item from a list — often paired with MATCH to look up in any direction. Full INDEX guide.
More INDEX practice questions
- Using INDEX, return the third item name from the list and put it in D2.
- Return the price of the fourth product in the list and put it in D2.
- Using INDEX, return the units for the second department in the third quarter and put it…
- The position number is typed in E2. Return the name at that position from the list and…
- Using INDEX with COUNTA, return the most recent (last filled) log entry and put it in…
- The row and column positions are typed in E2 and F2. Return the matching value from the…
- Using INDEX with ROWS, return the second-last name in the list and put it in D2.
- The From and To positions are typed in D2 and E2. Find the revenue growth (revenue at To…
All practice questions · Excel exercises · Interview prep · Cheat sheet