ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Finding Selling Prices Using Range Names and Cell Intersections
2
Duncan Williamson
3
4
Solution
5
XSmallSmallMediumLargeXLargeHighlight the range A5:F10
6
Socks#NUM!Formulas Ribbon … Defined Names … Create from Selection
7
Shorts#NUM!
8
Pants#NUM!
9
Tshirt#NUM!
10
Sweater#NUM!
11
12
ProductSizePrice
13
SweaterXlarge#ERROR!
14
=ARRAY_CONSTRAIN(ARRAYFORMULA(INDIRECT(A13) INDIRECT(B13)), 1, 1)
15
16
17
18
Enter your chosen products in A13 and B13
19
in D13 enter =INDIRECT(A13) INDIRECT(B13)
20
NOTICE the single SPACE between the two INDIRECT() functions
21
22
Done!
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100