Free practice
You just read about INDEX MATCH. Now type one.
Three INDEX MATCH questions, right here in the page. Type your formula, press Check, and you find out right away. No sign-up needed.
Question 1 of 3
Try it yourself
In I2, use INDEX and MATCH together to return the Price for the ID in H2.
A
B
C
D
E
F
G
H
I
J
K
L
M
1
2
3
4
5
6
7
8
9
10
11
Product ID
Product Name
Category
Price
Stock
Supplier
Lookup
Answer
SKU-101
Magnifying Glass
Optics
$24.99
45
Baker Street Supply
SKU-108
SKU-102
Forensic Chemistry Set
Laboratory
$45.00
30
Strand Chemical Co.
SKU-106
SKU-103
Pocket Watch
Accessories
$35.00
60
Regent Timeworks
SKU-101
SKU-104
Field Binoculars
Surveillance
$65.00
50
Strand Curiosities
SKU-107
SKU-105
Cipher Decoder
Cryptography
$28.50
120
Strand Curiosities
SKU-103
SKU-106
Evidence Bag Kit
Surveillance
$19.99
80
Yard Forensics
SKU-107
Night-Vision Scope
Surveillance
$15.00
25
Yard Forensics
SKU-108
Disguise Kit
Espionage
$89.99
15
Mycroft Imports
Still working through the theory? The INDEX MATCH guide covers the same ground in writing.