Free practice
You just read about XLOOKUP. Now type one.
Three XLOOKUP 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, write an XLOOKUP that returns the Product Name 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
Description
Search
Result
SKU-101
Magnifying Glass
Optics
$24.99
42
Evidence lens
SKU-103
SKU-102
Forensic Chemistry Set
Laboratory
$45.00
18
Trace-analysis kit
SKU-101
SKU-103
Pocket Watch
Accessories
$35.00
30
Engraved timepiece
SKU-105
SKU-104
Field Binoculars
Surveillance
$65.00
25
Stakeout binoculars
SKU-102
SKU-105
Cipher Decoder
Cryptography
$28.50
15
Code-breaking disc
SKU-104
SKU-106
Extendable Baton
Field Gear
$32.00
20
Collapsible baton
SKU-107
Evidence Bag
Forensics
$12.00
60
Sealed evidence bag
SKU-108
Brass Telescope
Optics
$89.99
8
Antique spyglass
Still working through the theory? The XLOOKUP guide covers the same ground in writing.