回答編集履歴
1
誤記訂正
test
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
```
|
|
30
30
|
|
|
31
|
-
=IF(ISNUMBER(MATCH(TRUE,INDEX(ISNUMBER(FIND($C$1:$C$11,$A
|
|
31
|
+
=IF(ISNUMBER(MATCH(TRUE,INDEX(ISNUMBER(FIND($C$1:$C$11,$A1)),),0)),INDEX($D$1:$D$11,MATCH(TRUE,INDEX(ISNUMBER(FIND($C$1:$C$11,$A1)),),0)),$E$1)
|
|
32
32
|
|
|
33
33
|
```
|
|
34
34
|
|