{"id":1163,"date":"2022-08-30T15:48:16","date_gmt":"2022-08-30T15:48:16","guid":{"rendered":"https:\/\/www.geekmungus.co.uk\/?p=1163"},"modified":"2022-11-05T10:53:18","modified_gmt":"2022-11-05T10:53:18","slug":"google-sheets-lookup-from-another-workbook","status":"publish","type":"post","link":"https:\/\/geekmungus.co.uk\/?p=1163","title":{"rendered":"Google Sheets &#8211; Lookup from Another Workbook"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">It is possible to create a lookup from one workbook to another. Let&#8217;s say you have a list on one workbook and you want this to appear as a list on a second workbook, here&#8217;s how you can do it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Get the List from the Source Workbook<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Firstly get the ID section of the URL for the workbook of which you want to lookup, i.e. the highlighted bit.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.geekmungus.co.uk\/wp-content\/uploads\/2022\/08\/image-2.png\" alt=\"\" class=\"wp-image-1164\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now you need to get the name of the sheet within that workbook, in my case its called <strong>&#8220;Information Assets&#8221;<\/strong>, then you just need to include the range, in my case this is <strong>$A$3:$A<\/strong>, or the whole of the A column starting from row 3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With that you can create the following equation:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMPORTRANGE(\"12IsCwjWyv9CvnRecTEsCwM7CjxbI9o_s3cxx\",\"Information Assets!$A$3:$A\")<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">On your destination workbook create another sheet which will be used as your Tables, Legend or Resource sheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Within this new sheet, click on a cell and paste in the equation above. You may then be asked to &#8220;Link&#8221; the workbooks together, after a few seconds you should see the list and cell information from the other workbook updated in this sheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These sheets are now linked. If you add something to that column in the source workbook, this list within the destination workbook will be updated automatically.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Make Use of the List<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Click on the Cell you want to make use of this list, select &#8220;Data&#8221;->&#8221;Data Validation&#8221;, then enter the reference to the whole of the imported range:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.geekmungus.co.uk\/wp-content\/uploads\/2022\/08\/image-3.png\" alt=\"\" class=\"wp-image-1165\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click &#8220;Save&#8221;, you should now have a drop down list containing the items imported from the other workbook via your intermediate worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is possible to create a lookup from one workbook to another. Let&#8217;s say you have a list on one workbook and you want this to appear as a list on a second workbook, here&#8217;s how you can do it. Get the List from the Source Workbook Firstly get the ID section of the URL &#8230; <a title=\"Google Sheets &#8211; Lookup from Another Workbook\" class=\"read-more\" href=\"https:\/\/geekmungus.co.uk\/?p=1163\" aria-label=\"Read more about Google Sheets &#8211; Lookup from Another Workbook\">Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-1163","post","type-post","status-publish","format-standard","hentry","category-random"],"_links":{"self":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1163"}],"version-history":[{"count":1,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1163\/revisions"}],"predecessor-version":[{"id":1306,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1163\/revisions\/1306"}],"wp:attachment":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}