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 Lookup Fallbacks
This intro problem practices IFNA. IFNA returns a fallback value when another formula returns the "#N/A" error. The Price column already uses VLOOKUP to look up each SKU in the table on the right. Update the output cells in the Price Clean column so any "#N/A" price becomes "None" and valid prices stay unchanged.
See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
Need help with IFNA details and syntax? Review the IFNA function guide first.
A1 expected value: *
