ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Database Section
3
Provider NumService 1Service 2
4
Provider 1YY
5
Provider 2NY
6
Provider 3NN
7
8
Formula Section
9
10
I can find providers that offer a particular service, no problem
11
12
Example 1
13
"Who Provides Service 1?" Static Formula
14
Provider 1Y
15
16
Notice that the formula is static because it explicitly relies on the "C" column.
17
How would we go about doing a similar formula when that column wasn't already known?
18
For example
19
20
Example 2
21
Service 1
22
23
24
Here are the Providers who provide that service
25
Provider 1
26
27
We could hard code it (if Service = 1 then C4:C6, etc.). But what if we added MANY more services?
28
Is there a way I can Search / Match / Find the filter condition's column?
29
30
31
32
33
hi
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