質問編集履歴
1
誤字修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -56,7 +56,7 @@
|
|
|
56
56
|
|
|
57
57
|
```
|
|
58
58
|
|
|
59
|
-
=INDEX(TableB!H1:TableB!H5,MATCH(TableA!A1&TableA!B1&TableA!C1,TableB!A1:TableB!A5&TableB!B1:TableB!B5&TableB!
|
|
59
|
+
=INDEX(TableB!H1:TableB!H5,MATCH(TableA!A1&TableA!B1&TableA!C1,TableB!A1:TableB!A5&TableB!B1:TableB!B5&TableB!C1:TableB!C5,0))
|
|
60
60
|
|
|
61
61
|
//Excel上ではTableAとTableBは別シート
|
|
62
62
|
|