Lookups·Lesson 31 of 62Pro
How to use INDEX and MATCH in Google Sheets
Look up in any direction
How INDEX + MATCH works
MATCH finds a position, and INDEX returns whatever sits at that position in another range. Together they look up in any direction.
INDEX(return range, MATCH(what, where, 0))
Example on this data
=INDEX(F2:F11,MATCH(1007,A2:A11,0))→30
Price for order 1007.
What you’ll do
You’ll find the units for one order by pairing two functions: one finds the row, the other returns the value there. This combination works in any version of Sheets or Excel.
Try it
Type =INDEX(F2:F11,MATCH(1007,A2:A11,0)) into K2 and press Enter. Watch what the sheet does.
The result will appear in K2.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Rep | Region | Product | Units | Price | Order date | Ship date | |||
| 2 | 1001 | Ana | West | Desk | 3 | 240 | 1/5/2026 | 1/9/2026 | |||
| 3 | 1002 | Bo | East | Chair | 8 | 85 | 1/12/2026 | 1/20/2026 | |||
| 4 | 1003 | Cy | West | Lamp | 12 | 30 | 1/19/2026 | 1/22/2026 | |||
| 5 | 1004 | Di | North | Desk | 2 | 240 | 2/2/2026 | 2/13/2026 | |||
| 6 | 1005 | Ana | West | Chair | 5 | 85 | 2/9/2026 | 2/12/2026 | |||
| 7 | 1006 | Eve | South | Shelf | 4 | 120 | 2/16/2026 | 2/27/2026 | |||
| 8 | 1007 | Bo | East | Lamp | 20 | 30 | 3/2/2026 | 3/4/2026 | |||
| 9 | 1008 | Cy | West | Shelf | 1 | 120 | 3/9/2026 | 3/18/2026 | |||
| 10 | 1009 | Di | North | Chair | 6 | 85 | 3/16/2026 | 3/19/2026 | |||
| 11 | 1010 | Eve | South | Desk | 7 | 240 | 3/23/2026 | 4/1/2026 |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how INDEX + MATCH works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In K2, find the units for order 1004 using INDEX and MATCH.
One payment, no subscription.