質問編集履歴
1
より具体的なコード
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -35,4 +35,30 @@
|
|
|
35
35
|
|
|
36
36
|
}
|
|
37
37
|
|
|
38
|
+
```
|
|
39
|
+
追記
|
|
40
|
+
```
|
|
41
|
+
function myFunction() {
|
|
42
|
+
var sh1 = SpreadsheetApp.getActiveSpreadsheet()
|
|
43
|
+
var sh2 = SpreadsheetApp.openById("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx")
|
|
44
|
+
var sheet1 = sh1.getSheetByName('アカウント情報')
|
|
45
|
+
var sheet2 = sh2.getSheetByName('マスターデータ')
|
|
46
|
+
var values = sheet2.getRange('B6:G999').getValues();
|
|
47
|
+
var cpid = findValue(values, "株式会社〇〇", 7);
|
|
48
|
+
|
|
49
|
+
Logger.log(cpid);
|
|
50
|
+
}
|
|
51
|
+
|
|
52
|
+
function findValue(values, value, column) {
|
|
53
|
+
var columnIndex = column - 1;
|
|
54
|
+
for (var i in values) {
|
|
55
|
+
if (values[i][0] == value) {
|
|
56
|
+
return values[i][columnIndex];
|
|
57
|
+
Logger.log(i)
|
|
58
|
+
;
|
|
59
|
+
}
|
|
60
|
+
}
|
|
61
|
+
return false;
|
|
62
|
+
|
|
63
|
+
}
|
|
38
64
|
```
|