回答編集履歴
3
修正
test
CHANGED
|
@@ -12,6 +12,6 @@
|
|
|
12
12
|
|
|
13
13
|
```EXCEL
|
|
14
14
|
|
|
15
|
-
=IF(SUMPRODUCT((
|
|
15
|
+
=IF(SUMPRODUCT((A2:D3=A5)*1)>0,INDEX(A1:D1,1,SUMPRODUCT((A2:D3=A5)*COLUMN(A2:D3))),"")
|
|
16
16
|
|
|
17
17
|
```
|
2
修正
test
CHANGED
|
@@ -12,6 +12,6 @@
|
|
|
12
12
|
|
|
13
13
|
```EXCEL
|
|
14
14
|
|
|
15
|
-
=IF(SUMPRODUCT((B2:E3=B5)*
|
|
15
|
+
=IF(SUMPRODUCT((B2:E3=B5)*1)>0,INDEX(B1:E1,1,SUMPRODUCT((B2:E3=B5)*COLUMN(B2:E3))),"")
|
|
16
16
|
|
|
17
17
|
```
|
1
追記
test
CHANGED
|
@@ -7,3 +7,11 @@
|
|
|
7
7
|
=INDEX(A1:D1,1,SUMPRODUCT((A2:D3=A5)*COLUMN(A2:D3)))
|
|
8
8
|
|
|
9
9
|
```
|
|
10
|
+
|
|
11
|
+
検索でHITしないケースがあるのであれば、
|
|
12
|
+
|
|
13
|
+
```EXCEL
|
|
14
|
+
|
|
15
|
+
=IF(SUMPRODUCT((B2:E3=B5)*COLUMN(B2:E3))>0,INDEX(B1:E1,1,SUMPRODUCT((B2:E3=B5)*COLUMN(B2:E3))),"")
|
|
16
|
+
|
|
17
|
+
```
|