Spreadsheet: 836820d1689673750-find-several-values-separated-by-a-comma-and-return-a-value-with-no-duplicates-search-dataset
Sheet: Blad1

# | RS | Topic | Dimension | Art 1 | Art 2
 | I want to search for "#" and link that value to "RS".  "#" and "RS" are located in sheet 3 and sheet 4.  It would be convenient if the results of the found values from sheet 3 and sheet 4 are displayed in column B of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result. | I want to search for "#" and link that value to "topics".  "#" and "topics" are located in sheet 2.  It would be great if the results of the found values from sheet 2 are displayed in column C of sheet 1. Duplicate values should be omitted.  An example of the result is provided in the cell below. | I want to search for "#" and link that value to "Dimension".  "#" and "Dimension" are located in sheet 2.  It would be great if the results of the found values from sheet 2 are displayed in column D of sheet 1. Duplicate values should be omitted.  An example of the result is provided in the cell below. | I want to search for "#" and link that value to "Art 1".  "#" and "Art 1" are located in sheet 3.  It would be convenient if the results of the found values from sheet 3 are displayed in column E of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result. | I want to search for "#" and link that value to "Art 2".  "#" and "Art 2" are located in sheet 4.  It would be convenient if the results of the found values from sheet 3 are displayed in column F of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result.
1 |  | Information Protection | Process, Management, Employees, | 27001:2022 5.1, 27001:2022 5.3, | 27002:2022 5.1, 27002:2022 75.10, 27002:2022 7.7
2 | 6.46, 6.58
3 | 6.04, 6.08, 6.4, 6.81
4 | 6.38, 6.46
5 | 6.38, 6.46
6 | 6.67
7 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.37, 6.42, 6.43, 6.44, 6.67
8 | 6.01, 6.01, 6.01, 6.02, 6.02, 6.02, 6.03, 6.03, 6.03, 6.04, 6.08, 6.08, 6.09, 6.09, 6.09, 6.13, 6.13, 6.13, 6.14, 6.14, 6.17, 6.17, 6.18, 6.18, 6.18, 6.2, 6.21, 6.21, 6.21, 6.22, 6.35, 6.39, 6.4, 6.4, 6.46, 6.63, 6.69, 6.7, 6.7, 6.71, 6.72, 6.73, 6.74, 8.85
9 | 5.04, 5.05, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.11, 5.12, 5.12, 5.14, 6.12, 6.38, 6.39, 6.4, 6.46, 6.77
10 | 5.07, 6.04, 6.04, 6.04, 6.08, 6.08, 6.08, 6.08, 6.08, 6.17, 6.2, 6.38, 6.39, 6.39, 6.39, 6.4, 6.4, 6.4, 6.4, 6.41, 6.46, 8.85
11 | 6.46, 6.81
12 | 6.37, 6.64, 6.65
13 | 5.08, 6.1, 6.11, 6.83
14 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44
15 | 6.02, 6.11, 9.01, 9.02
16 | 6.02, 6.11, 9.01, 9.02
17 | 6.04, 6.08, 6.1, 6.11, 6.36, 6.4, 6.47, 6.7
18 | 6.6
19 | 6.17, 9.03
20 | 6.38, 6.46, 6.53, 6.55, 6.69
21 | 6.71
22 | 6.12, 6.18, 6.18, 6.21, 6.23, 6.23, 6.3, 6.3, 6.31
23 | 6.35, 6.74
24 | 6.38, 6.44, 6.77
25
26 | 6.46, 6.47
27 | 6.46, 6.7
28 | 6.46
29 | 6.46, 6.6, 6.63
30 | 5.05, 5.11, 5.12, 6.12, 6.38, 6.39, 6.4, 6.46, 6.77
31 | 6.46
32 | 6.01, 6.01, 6.02, 6.02, 6.03, 6.03, 6.04, 6.04, 6.04, 6.06, 6.08, 6.08, 6.08, 6.08, 6.09, 6.09, 6.13, 6.13, 6.14, 6.14, 6.15, 6.17, 6.17, 6.17, 6.18, 6.18, 6.19, 6.2, 6.2, 6.2, 6.21, 6.21, 6.22, 6.31, 6.35, 6.36, 6.36, 6.39, 6.4, 6.4, 6.4, 6.41, 6.42, 6.44, 6.47, 6.7, 6.71, 6.73, 6.76
33 | 6.12, 6.18, 6.18, 6.19, 6.2, 6.2, 6.21, 6.22, 6.23, 6.23, 6.3, 6.3, 6.3, 6.31, 6.31, 6.43, 6.72, 6.73, 6.73
34 | 6.06, 6.12, 6.15, 6.17, 6.18, 6.18, 6.2, 6.2, 6.21, 6.22, 6.23, 6.23, 6.3, 6.3, 6.31, 6.31, 6.35, 6.35, 6.36, 6.38, 6.42, 6.43, 6.44, 6.72, 6.73, 6.74, 6.77
35 | 5.08, 6.05, 6.06, 6.07, 6.15, 6.25, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.83
36 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.25, 6.32, 6.33, 6.35, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.47
37
38 | 6.35, 6.35, 6.74
39
40 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.21
41
42 | 6.6
43 | 5.01, 6.31, 6.34
44 | 6.07, 6.17, 6.2, 6.31, 6.35, 6.36, 6.44
45 | 6.1, 6.11
46 | 6.08, 6.08, 6.39, 6.39, 6.4, 6.4
47 | 6.01, 6.02, 6.03, 6.09, 6.13
48 | 6.17, 6.22, 6.22, 6.4
49 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12
50 | 5.05, 5.11, 5.12, 6.05, 6.05, 6.05, 6.06, 6.06, 6.07, 6.07, 6.12, 6.15, 6.15, 6.25, 6.25, 6.25, 6.25, 6.32, 6.32, 6.33, 6.33, 6.35, 6.35, 6.36, 6.36, 6.36, 6.37, 6.37, 6.37, 6.39, 6.4, 6.42, 6.42, 6.43, 6.43, 6.44, 6.44, 6.63, 6.66
51
52 | 6.33, 6.37, 6.45, 6.46, 6.48, 6.58, 6.61
53 | 6.46, 6.64
54 | 6.41, 6.41, 6.47
55 | 6.34, 6.41, 6.47
56 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.24, 6.25, 6.33, 6.41, 6.42, 6.45, 6.45
57 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.24, 6.25, 6.33, 6.38, 6.41, 6.42, 6.45, 6.45, 6.55
58 | 6.33, 6.45, 6.45
59 | 6.01, 6.01, 6.02, 6.02, 6.03, 6.03, 6.09, 6.09, 6.13, 6.13, 6.14, 6.14, 6.17, 6.17, 6.18, 6.18, 6.21, 6.21
60 | 6.05, 6.66
61 | 6.02, 6.11, 6.64, 6.65, 6.66, 9.01, 9.02
62 | 5.05, 5.11, 5.12, 6.12, 6.37, 6.39, 6.4, 6.45, 6.66
63 | 6.68
64 | 5.1, 6.69
65 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12
66 | 6.17, 6.22, 6.4
67 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.21
68 | 6.17, 6.17
69
70 | 6.07, 6.44
71 | 6.41, 6.47
72 | 5.08, 6.1, 6.1, 6.11, 6.11, 6.83
73
74
75 | 6.1, 6.11
76 | 5.1
77 | 5.08, 6.17, 6.83
78 | 6.18, 6.23, 6.3
79 | 6.38, 6.44, 6.77
80 | 6.18, 6.23, 6.3
81
82 | 6.15, 6.2, 6.36, 6.42
83
84
85
86
87
88
89
90
91
92
93 | 6.52, 6.61
94 | 6.58
95
96
97
98
99
100
101 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12
102
103
104
105
106
107
108 | 6.35
109 | 6.26, 6.27, 6.28, 6.35
110
111
112
113
114
115
116 | 6.17
117 | 6.17
118 | 6.17
119
120
121
122
123
124
125
126
127 | 6.23, 6.3
128
129
130
131
132
133
134 | 6.52, 6.61
135 | 6.38
136 | 6.61
137 | 6.52
138
139
140 | 6.61
141
142 | 5.08, 6.83
143
144
145
146
147