{"id":106489,"date":"2024-02-28T17:25:28","date_gmt":"2024-02-28T08:25:28","guid":{"rendered":"https:\/\/support.questetra.com\/?p=106489"},"modified":"2026-05-18T15:53:48","modified_gmt":"2026-05-18T06:53:48","slug":"google-sheets-two-valueranges-xlookup-reference-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-two-valueranges-xlookup-reference-2021\/","title":{"rendered":"Google Sheets: Two ValueRanges, Xlookup Reference"},"content":{"rendered":"\n<div style=\"text-align: center; background: #FFFF66; margin: 1em; padding: 1em;\"> <h3><span class=\"material-icons\">warning<\/span> PAGE UPDATED<\/h3> <a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-two-valueranges-xlookup-reference-202604\/\">https:\/\/support.questetra.com\/ja\/addons\/google-sheets-two-valueranges-xlookup-reference-202604\/<\/a> <\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Google Sheets: Two ValueRanges, Xlookup Reference<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the corresponding string in range C. If there is no match an empty string is returned. The search is executed in order from the top.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> U: Select HTTP_Authz Setting<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A: Set FILE-ID in Drive<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set ValueRange to Search (e.g. &#8220;B:B&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> b: Set LookupString to Serch for (e.g. &#8220;JP&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C: Set ValueRange to Return (e.g. &#8220;A:A&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> c: Select STRING that stores Returned String (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting     = configs.get      ( &quot;AuthzConfU&quot; );   \/\/\/ REQUIRED\n  engine.log( &quot; AutomatedTask Config: Authz Setting: &quot; + strAuthzSetting );\nconst strInputfileId      = configs.get      ( &quot;StrConfA1&quot; );    \/\/\/ REQUIRED\n  if( strInputfileId    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: FileID} is empty \\n&quot; );\n  }\nconst strSearchRange      = configs.get      ( &quot;StrConfB1&quot; );    \/\/\/ REQUIRED\nconst strReturnRange      = configs.get      ( &quot;StrConfC1&quot; );    \/\/\/ REQUIRED\nconst strSearch           = configs.get      ( &quot;StrConfB2&quot; );    \/\/\/ REQUIRED\nconst strPocketReturn     = configs.getObject( &quot;SelectConfC2&quot; ); \/\/\/ REQUIRED\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Get Ranges\n\/\/\/ Sheets for Developers &gt; API v4\n\/\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/batchGet\n\/\/ request1, prepare\nlet request1Uri = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; + strInputfileId + &quot;\/values:batchGet&quot;;\nlet request1    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1    = request1.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n    request1    = request1.queryParam( &quot;majorDimension&quot;, &quot;ROWS&quot; );\n    request1    = request1.queryParam( &quot;valueRenderOption&quot;, &quot;FORMATTED_VALUE&quot; ); \n                 \/\/ Even if formatted as currency, return &quot;$1.23&quot; not &quot;1.23&quot;.\n    request1    = request1.queryParam( &quot;dateTimeRenderOption&quot;, &quot;FORMATTED_STRING&quot; ); \n                 \/\/ Date as strings (the spreadsheet locale) not SERIAL_NUMBER\n    request1  = request1.queryParam( &quot;ranges&quot;, strSearchRange );\n    request1  = request1.queryParam( &quot;ranges&quot;, strReturnRange );\n\/\/ request1, try\nconst response1     = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + request1Uri );\nconst response1Code = response1.getStatusCode() + &quot;&quot;;\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\/\/ response1, parse\n\/* \nengine.log( response1Body ); \/\/ debug\n{\n  &quot;spreadsheetId&quot;: &quot;1GOoZQmsExM7GoG6Uqa6R-_SujKVJu5SqrYLBqoQ378M&quot;,\n  &quot;valueRanges&quot;: [\n    {\n      &quot;range&quot;: &quot;&#39;country-code&#39;!B1:B1000&quot;,\n      &quot;majorDimension&quot;: &quot;ROWS&quot;,\n      &quot;values&quot;: [\n        [\n          &quot;AF&quot;\n        ],\n        [\n          &quot;AX&quot;\n        ],\n        [\n          &quot;AL&quot;\n        ],,,,\n        [\n          &quot;ZW&quot;\n        ]\n      ]\n    },\n    {\n      &quot;range&quot;: &quot;&#39;country-code&#39;!A1:A1000&quot;,\n      &quot;majorDimension&quot;: &quot;ROWS&quot;,\n      &quot;values&quot;: [\n        [\n          &quot;Afghanistan&quot;\n        ],\n        [\n          &quot;Aland Islands&quot;\n        ],\n        [\n          &quot;Albania&quot;\n        ],,,,\n        [\n          &quot;Zimbabwe&quot;\n        ]\n      ]\n    }\n  ]\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\n\n\/\/\/ Xlookup\n\/\/ converts valueRange to Multiline String\nlet strMultilineSearch = &quot;&quot;;\n  for( let j = 0; j &lt; response1Obj.valueRanges[0].values.length; j++ ){\n    for( let k = 0; k &lt; response1Obj.valueRanges[0].values[j].length; k++ ){\n      strMultilineSearch += response1Obj.valueRanges[0].values[j][k];\n      if( k != response1Obj.valueRanges[0].values[j].length - 1 ){\n        strMultilineSearch += &quot; &quot;;\n      }\n    }\n    if( j != response1Obj.valueRanges[0].values.length - 1 ){\n      strMultilineSearch += &quot;\\n&quot;;\n    }\n  }\nlet strMultilineReturn = &quot;&quot;;\n  for( let j = 0; j &lt; response1Obj.valueRanges[1].values.length; j++ ){\n    for( let k = 0; k &lt; response1Obj.valueRanges[1].values[j].length; k++ ){\n      strMultilineReturn += response1Obj.valueRanges[1].values[j][k];\n      if( k != response1Obj.valueRanges[1].values[j].length - 1 ){\n        strMultilineReturn += &quot; &quot;;\n      }\n    }\n    if( j != response1Obj.valueRanges[1].values.length - 1 ){\n      strMultilineReturn += &quot;\\n&quot;;\n    }\n  }\n\/\/ searches for a multiline string with a search term\nlet strReturn = &quot;&quot;;\nconst arrSearch = strMultilineSearch.split(&quot;\\n&quot;);\nconst arrReturn = strMultilineReturn.split(&quot;\\n&quot;);\nfor( let i = 0; i &lt; arrSearch.length; i++ ){\n  if( strSearch === arrSearch[i] ){\n    strReturn   = arrReturn[i];\n    engine.log( &quot; AutomatedTask Lookup: Match ID &quot; + i );\n    break;\n  }\n}\nif( strReturn === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask Lookup: No Match&quot; );\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketReturn,    strReturn );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- Convert by referring to the master information (employee master, etc.) in the spreadsheet.\n    - Example: Employee ID to Employee name \/ Employee name to Employee ID\n    - Example: Country name to Country code \/ Country code to Country name\n- The File ID can be obtained from the URI or the sharing settings screen.\n    - docs.google.com\/spreadsheets\/d\/{File-ID}\/edit#gid=0\n- The number of elements in the two ranges must be the same.\n- How to specify the range depends on Google API A1 notation. (see APPENDIX)\n- If multiple, each element will be string in which all cells are concatenated with spaces.\n    - Example: Employee name data is stored separately in &quot;{Firstname cell} {Lastname Cell}&quot;\nNotes-ja:\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u30de\u30b9\u30bf\u30fc\u60c5\u5831\uff08\u793e\u54e1\u30de\u30b9\u30bf\u7b49\uff09\u3092\u4f7f\u3063\u3066\u3001\u30c7\u30fc\u30bf\u5909\u63db\u3067\u304d\u307e\u3059\u3002\n    - \u4f8b\uff1a\u793e\u54e1ID\u2192\u793e\u54e1\u306e\u540d\u524d\u3001\u793e\u54e1\u306e\u540d\u524d\u2192\u793e\u54e1ID\u3001\u56fd\u540d\u2192\u56fd\u30b3\u30fc\u30c9\u3001\u56fd\u30b3\u30fc\u30c9\u2192\u56fd\u540d\n- \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 ID \u306f URL \u7b49\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - docs.google.com\/spreadsheets\/d\/{File-ID}\/edit#gid=0\n- 2\u3064\u306e\u7bc4\u56f2\u306e\u8981\u7d20\u6570\u306f\u3001\u540c\u6570\u3067\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002\n- \u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5\u306f Google API \u306e A1 notation \u306b\u4f9d\u308a\u307e\u3059 (Appendix\u53c2\u7167)\n- \u8907\u6570\u30bb\u30eb\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u300c\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u7d50\u5408\u3055\u308c\u305f\u6587\u5b57\u5217\u300d\u304c\u63a2\u7d22\u5bfe\u8c61\uff0f\u30ea\u30bf\u30fc\u30f3\u5bfe\u8c61\u3068\u306a\u308a\u307e\u3059\u3002\n    - A\u5217\u306b\u300c\u59d3\u300d\u304c\u3001B\u5217\u306b\u300c\u540d\u300d\u304c\u3001\u5206\u3051\u3066\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u7bc4\u56f2\u6307\u5b9a\u306f &quot;A:B&quot; \u3068\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n\nAPPENDIX-en\n- A1 Notation\n    - https:\/\/developers.google.com\/sheets\/api\/guides\/concepts#a1_notation\n    - &quot;Sheet1!A1:B2&quot; refers to the first two cells in the top two rows of Sheet1.\n    - &quot;Sheet1!A:A&quot; refers to all the cells in the first column of Sheet1.\n    - &quot;Sheet1!1:2&quot; refers to the all the cells in the first two rows of Sheet1.\n    - &quot;Sheet1!A5:A&quot; refers to all the cells of the first column of Sheet 1, from row 5 onward.\n    - &quot;A1:B2&quot; refers to the first two cells in the top two rows of the first visible sheet.\n    - &quot;Sheet1&quot; refers to all the cells in Sheet1.\n- Setting example of &quot;HTTP Authentication&quot; (OAuth2)\n    - Authorization Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n    - Token Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/token\n    - Scope:\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n    - Client ID, Consumer Secret:\n        - ( from https:\/\/console.developers.google.com\/ )\n        - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\nAPPENDIX-ja\n- A1\u8a18\u6cd5\uff08A1 Notation\uff09\n    - https:\/\/developers.google.com\/sheets\/api\/guides\/concepts#a1_notation\n    - &quot;Sheet1!A1:B2&quot; \u300cSheet1\u300d\u306e\u4e0a2\u884c\u306e\u5148\u982d2\u30bb\u30eb\uff08\u5408\u8a084\u30bb\u30eb\uff09\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - &quot;Sheet1!A:A&quot; \u300cSheet1\u300d\u306eA\u5217\u306e\u5168\u3066\u306e\u30bb\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - &quot;Sheet1!1:2&quot; \u300cSheet1\u300d\u306e\u4e0a2\u884c\u306b\u3042\u308b\u3059\u3079\u3066\u306e\u30bb\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - &quot;Sheet1!A5:A&quot; \u300cSheet1\u300d\u306eA\u52175\u884c\u76ee\u4ee5\u964d\u306e\u3059\u3079\u3066\u306e\u30bb\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - &quot;A1:B2&quot; \u6700\u521d\u306b\u8868\u793a\u3055\u308c\u308b\u30b7\u30fc\u30c8\u306e\u4e0a2\u884c\u306e\u5148\u982d2\u30bb\u30eb\uff08\u5408\u8a084\u30bb\u30eb\uff09\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - &quot;Sheet1&quot; \u300cSheet1\u300d\u306e\u3059\u3079\u3066\u306e\u30bb\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n- &quot;HTTP\u8a8d\u8a3c&quot;\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n    - Authorization Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n    - Token Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/token\n    - Scope:\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n    - Client ID, Consumer Secret:\n        - ( from https:\/\/console.developers.google.com\/ )\n        - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC3ElEQVRYR8WXbUgTcRzHv\/85bZvF\nZmMwLKwXgkEUGFFKvSi6EoLe+M7IF3lGWtATQW9615uMKOlFaroFKc1XRvSiF14YPUBEtfKFpPlC\nI1TQ2q10Tr3dP3bzxm7e7e7m6u717+Fzv+c\/gcUfMeq\/vOuEa9EWq6dF5DAoqkGxHQRlkj5FBAQT\nIAiTBB1yiq6BqbPPYkZs6wL4Hh7yr4j2awRooYDDoNE4BTqLbULb7OmXM7l0cgKUBY62UNDbAEqN\nOFaRWSAgVyPsYKeWviaAO8jcJxSteTpWqFGCjmgTd07NliqAO8A8JkBDIZzLNigQirLcyWybawAK\n+efZztQioQBYzXlHtuK9g1fQUHkMdluRalCWRQH944O4+OaObtAISGtmTaQBVqt9XK3g3tX3oMqz\nTdP45J8ZiBDxevqLEYiFYptQKXdHGsATYO4CuKTmRQ9glJ\/E9fcPcKv2vFGIdp7lLid9SQDSkLEv\n\/tTqcyMANQPNYLbuMwRBgLhTcHqTw0oCKOs+coraSK9WjPUAYkIcr6Y+I7o8j43FTtT6d6F75Clu\nhh9ppo2ItDFy5kWfBOAJMgFQNOULoKbXO\/YcF3IVJUGQb+LYFECA+QSg+r8CAGGe5fakAHqYX+nF\nokKhl4K8IkAR4Zu5zXIEaK4GzgTgl+YxNPURy4kVhYrf5cUB\/+70rNBNAQCe5YhpgOnYHEb579jr\n24EPs1+xpdQHr8ONt9PDqKuoQYnNLoGZAzCRgiRA6Nug5Hj89w94N7ixqcSFuLCExqrjxgGyUmC4\nCAsGoChCE21YsBRktqGZQVSoIlQMovWOYrNtuGYUrw6jvJeRWQAAymWUNJBrHYeYG6ir2A+S2l26\nXzyxhLZwH9qH+9Vk1dextJRSR+iag6S81IfWnfXwOTy6zpMC4bkxdI08UZXVPEhkaUtPsjSElUfp\nv4iE6bNchrD0YSJDWPo0yyxjyx6nhvpuHUJ\/AerAujDWZMynAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1nimjSzB1RwdfSA9SpQRPyHJmeEIHB0r2\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-05-10 (C) Questetra, Inc. (MIT License)<gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1h7fvvLzbzq8bPsxjBJ7BYsgIWI363kN_\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Google-Sheets-Two-ValueRanges-Xlookup-Reference-2024.xml<\/a><gwmw style=\"display:none;\"><\/gwmw>\n<ul class=\"wp-block-list\">\n<li>2024-02-28 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for \u201cGraalJS standard (engine-type 3)\u201d on v15.0 or above<gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"> The Addon-import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Convert by referring to the master information in the spreadsheet (employee master, etc.).\n<ul class=\"wp-block-list\">\n<li>Example: Employee ID to Employee name \/ Employee name to Employee ID<\/li>\n\n\n\n<li>Example: Country name to Country code \/ Country code to Country name<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The File ID can be obtained from the URI or the sharing settings screen.\n<ul class=\"wp-block-list\">\n<li>docs.google.com\/spreadsheets\/d\/SPREADSHEETID}\/edit#gid=0<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The number of elements in the two ranges must be the same.<\/li>\n\n\n\n<li>How to specify the range depends on Google API A1 notation. (see APPENDIX)<\/li>\n\n\n\n<li>If multiple cells are specified, strings in which all cells are concatenated with spaces will be returned.\n<ul class=\"wp-block-list\">\n<li>Example: Employee name data is stored separately in &#8220;{Firstname cell} {Lastname Cell}&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"106492\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-two-valueranges-xlookup-reference-2021\/attachment\/google-sheets-two-valueranges-xlookup-reference-2021-execution-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Converts stringB to stringC, referring to the two areas. Searches lookup_string in range B, and if an exact match, returns the corresponding string in range C. If no match, an empty string is returned. The search is executed in order from the top.\" class=\"wp-image-106492\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-execution-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"809\" data-attachment-id=\"106494\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-two-valueranges-xlookup-reference-2021\/attachment\/google-sheets-two-valueranges-xlookup-reference-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?fit=883%2C809&amp;ssl=1\" data-orig-size=\"883,809\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?fit=688%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?resize=883%2C809&#038;ssl=1\" alt=\"Converts stringB to stringC, referring to the two areas. Searches lookup_string in range B, and if an exact match, returns the corresponding string in range C. If no match, an empty string is returned. The search is executed in order from the top.\" class=\"wp-image-106494\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?w=883&amp;ssl=1 883w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?resize=344%2C315&amp;ssl=1 344w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?resize=688%2C630&amp;ssl=1 688w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-config-en.png?resize=768%2C704&amp;ssl=1 768w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A1 Notation\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/developers.google.com\/sheets\/api\/guides\/concepts#a1_notation\" rel=\"nofollow\">https:\/\/developers.google.com\/sheets\/api\/guides\/concepts#a1_notation<\/a><\/li>\n\n\n\n<li>&#8220;Sheet1!A1:B2&#8221; refers to the first two cells in the top two rows of Sheet1.<\/li>\n\n\n\n<li>&#8220;Sheet1!A:A&#8221; refers to all the cells in the first column of Sheet1.<\/li>\n\n\n\n<li>&#8220;Sheet1!1:2&#8221; refers to the all the cells in the first two rows of Sheet1.<\/li>\n\n\n\n<li>&#8220;Sheet1!A5:A&#8221; refers to all the cells of the first column of Sheet 1, from row 5 onward.<\/li>\n\n\n\n<li>&#8220;A1:B2&#8221; refers to the first two cells in the top two rows of the first visible sheet.<\/li>\n\n\n\n<li>&#8220;Sheet1&#8221; refers to all the cells in Sheet1.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Setting example of &#8220;HTTP Authentication&#8221; (OAuth2)\n<ul class=\"wp-block-list\">\n<li>Authorization Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&#038;approval_prompt=force\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&#038;approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Token Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/token\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/token<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Scope:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Client ID, Consumer Secret:\n<ul class=\"wp-block-list\">\n<li>( from <a href=\"https:\/\/console.developers.google.com\/\" rel=\"nofollow\">https:\/\/console.developers.google.com\/<\/a> )<\/li>\n\n\n\n<li>Redirect URLs: <a href=\"https:\/\/s.questetra.net\/oauth2callback\" rel=\"nofollow\">https:\/\/s.questetra.net\/oauth2callback<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Ij5TY6QmHa\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/\">Google Sheets: Sheet, Append TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google Sheets: Sheet, Append TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/google-sheets-sheet-append-tsv\/embed\/#?secret=tceOsa56Eq#?secret=Ij5TY6QmHa\" data-secret=\"Ij5TY6QmHa\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"UrUNZJeMJF\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/\">Google Sheets: Sheet Row, Update with Singleline TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google Sheets: Sheet Row, Update with Singleline TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/embed\/#?secret=kvyMqHFoLd#?secret=UrUNZJeMJF\" data-secret=\"UrUNZJeMJF\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the corresponding string in range C. If there is no match an empty string is returned. The search is executed in order from the top.<\/p>\n","protected":false},"author":2,"featured_media":106490,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Converts stringB to stringC, referring to the two areas. Searches lookup_string in range B, and if an exact match, returns the corresponding string in range C. If no match, an empty string is returned. The search is executed in order from the top.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[396,3162],"class_list":["post-106489","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-google-sheets-api-v4","tag-google-workspace"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":2,"uagb_excerpt":"Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the corresponding string in range C. If there is no match an empty string is returned. The search is executed in order from the top.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-rHz","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":84387,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-master-table-simple-xlookup\/","url_meta":{"origin":106489,"position":0},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb, \u30b7\u30f3\u30d7\u30eb Xlookup","author":"IMAMURA, Genichi","date":"2020-02-06","format":false,"excerpt":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5185\u306e\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u3066\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002\u914d\u5217C\u306e\u4e2d\u306b\u691c\u7d22\u8a9e\u3092\u691c\u7d22\u3057\u3001\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u8981\u7d20\u304c\u3042\u308c\u3070\u3001\u305d\u308c\u306b\u5bfe\u5fdc\u3059\u308b\u914d\u5217D\u5185\u306e\u5024\uff08\u540c\u3058\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5024\uff09\u3092\u8fd4\u3057\u307e\u3059\u3002\u63a2\u7d22\u914d\u5217C\u3068\u30ea\u30bf\u30fc\u30f3\u914d\u5217D\u306f\u3001A1\u8a18\u6cd5\u3067\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u914d\u5217C\u3068\u914d\u5217D\u306e\u9577\u3055\u304c\u540c\u6570\u3067\u306a\u3044\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb, \u30b7\u30f3\u30d7\u30eb Xlookup","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81195,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-values-export-as-tsv\/","url_meta":{"origin":106489,"position":1},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u7bc4\u56f2\u30c7\u30fc\u30bf, TSV\u30a8\u30af\u30b9\u30dd\u30fc\u30c8","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"\u77e9\u5f62\u7bc4\u56f2\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092TSV\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u884c\u306etab\u533a\u5207\u308a\u306e\u6570\u306f\u5747\u4e00\u3068\u306a\u308a\u307e\u3059\u3002\u30c7\u30fc\u30bf\u306e\u7121\u3044\u30bb\u30eb\u306f\u7a7a\u6587\u5b57\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\uff12\u7bc4\u56f2\u306e\u540c\u6642\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3082\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u898b\u51fa\u3057\u90e8\u3068\u76f4\u8fd1\u30c7\u30fc\u30bf\u306e\u540c\u6642\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u304c\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Export-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Export-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Export-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Export-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Export-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81022,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-values-sum-numbers\/","url_meta":{"origin":106489,"position":2},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u7bc4\u56f2\u30c7\u30fc\u30bf, \u6570\u5024\u5408\u8a08","author":"IMAMURA, Genichi","date":"2019-10-18","format":false,"excerpt":"\u6307\u5b9a\u7bc4\u56f2\u306b\u3042\u308b\u6570\u5024\u3092\u5408\u8a08\u3057\u307e\u3059\u3002\u6570\u5024\u3068\u8a8d\u8b58\u3067\u304d\u306a\u3044\u30bb\u30eb\u306e\u5024\u306f\u30bc\u30ed\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\uff12\u7bc4\u56f2\u306e\u540c\u6642\u8a08\u7b97\u3082\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u7dcf\u52d8\u5b9a\u5143\u5e33\u306e\u501f\u65b9\u8cb8\u65b9\u3092\u540c\u6642\u306b\u5408\u7b97\u3067\u304d\u308b\u305f\u3081\u3001\u4e88\u7b97\u306e\u6d88\u5316\u9032\u6357\u3092\u30b9\u30e0\u30fc\u30ba\u306b\u96c6\u8a08\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67342,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/googlesheets-getidslabels\/","url_meta":{"origin":106489,"position":3},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u9078\u629e\u80a2\u30c7\u30fc\u30bf\u306e\u4e00\u62ec\u53d6\u5f97","author":"suesesayaka","date":"2024-07-05","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u6307\u5b9a\u3057\u305f2\u5217\u306b\u5165\u3063\u3066\u3044\u308b\u9078\u629e\u80a2\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":106489,"position":4},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"\u5358\u4e00\u884cTSV\u30c7\u30fc\u30bf\u3067Google\u30b7\u30fc\u30c8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002TSV\u306e\u5148\u982d\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308bA\u30bb\u30eb\u3092\u63a2\u7d22\u3057\u3001\u6700\u521d\u306b\u5408\u81f4\u3057\u305f\u884c\u306b\u3064\u3044\u3066\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u5024\u306f\u3001\u624b\u5165\u529b\u3057\u305f\u969b\u3068\u540c\u69d8\u306b\u81ea\u52d5\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u5408\u81f4\u3059\u308b\u884c\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u672b\u5c3e\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":106489,"position":5},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/106489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=106489"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/106489\/revisions"}],"predecessor-version":[{"id":184272,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/106489\/revisions\/184272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/106490"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=106489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=106489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=106489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}