A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Intro Rate Lookup
This intro problem practices XLOOKUP. XLOOKUP searches one range for a value and returns the matching value from another range. Update the output cells so each order row shows the rate for its plan from the rate table.
See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
Need help with XLOOKUP details and syntax? Review the XLOOKUP function guide first.
A1 expected value: *
