Sheets ExercisesFree · Lesson 12: XLOOKUP
0 pts
✕
0
Step 1 of 4

Return a value to the left

In G2, find the ID in F2 within C2:C5 and return the matching name from A2:A5.

Show formula shape
=XLOOKUP(search key, lookup range, result range)
100%
G2fx
A
B
C
D
E
F
G
H
1
Name
Department
Employee ID
Email
Search ID
Result
2
Ana
Operations
E-101
ana@example.com
E-103
3
Bo
Sales
E-102
bo@example.com
E-104
4
Cam
Finance
E-103
cam@example.com
E-999
5
Dee
Operations
E-104
dee@example.com
E-102
6
7
8
9
10
11
Team directory
G2