{"id":3226,"date":"2017-01-12T15:22:18","date_gmt":"2017-01-12T14:22:18","guid":{"rendered":"https:\/\/www.nemprogrammering.dk\/wp\/?p=3226"},"modified":"2017-10-11T22:40:12","modified_gmt":"2017-10-11T20:40:12","slug":"lopslag-vlookup-google-sheets","status":"publish","type":"post","link":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/","title":{"rendered":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!"},"content":{"rendered":"<p>I denne video skal vi se p\u00e5 en meget kendt funktion kaldet LOPSLAG eller VLOOKUP p\u00e5 engelsk. Med denne funktioner kan du lede efter et talt eller stykke tekst i en tabel og returnere det tal eller tekst som st\u00e5r i samme r\u00e6kke.<\/p>\n<p>Hvis du eksempelvis har en r\u00e6kke med id og en r\u00e6kke med navn, s\u00e5 kan du med LOPSLAG sl\u00e5 op et id op i tabellen og f\u00e5 navnet p\u00e5 personen med det id tilbage. Det kan v\u00e6re lidt sv\u00e6rt at forklare, men videoen skulle gerne g\u00f8re det mere klart.<\/p>\n<p>LOPSLAG \/ VLOOKUP findes ogs\u00e5 i Excel, s\u00e5 m\u00e5ske kender du allerede funktionen herfra.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I denne video skal vi se p\u00e5 en meget kendt funktion kaldet LOPSLAG eller VLOOKUP p\u00e5 engelsk. Med denne funktioner kan du lede efter et talt eller stykke tekst i en tabel og returnere det tal eller tekst som st\u00e5r i samme r\u00e6kke. Hvis du eksempelvis har en r\u00e6kke med id og en r\u00e6kke med [&hellip;]<\/p>\n","protected":false},"author":166,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"video.php","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[],"class_list":["post-3226","post","type-post","status-publish","format-standard","hentry","category-google-sheets-serie-v-1"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!<\/title>\n<meta name=\"description\" content=\"I denne danske video-guide ser vi p\u00e5, hvordan du kan sl\u00e5 op i dine tabeller og lede efter data ved hj\u00e6lp af LOPSLAG, p\u00e5 engelsk VLOOKUP.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!\" \/>\n<meta property=\"og:description\" content=\"I denne danske video-guide ser vi p\u00e5, hvordan du kan sl\u00e5 op i dine tabeller og lede efter data ved hj\u00e6lp af LOPSLAG, p\u00e5 engelsk VLOOKUP.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"NemProgrammering.dk\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-12T14:22:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-10-11T20:40:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2016\/03\/logo2015.png\" \/>\n\t<meta property=\"og:image:width\" content=\"410\" \/>\n\t<meta property=\"og:image:height\" content=\"73\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Redaktionen\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"Redaktionen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minut\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!","description":"I denne danske video-guide ser vi p\u00e5, hvordan du kan sl\u00e5 op i dine tabeller og lede efter data ved hj\u00e6lp af LOPSLAG, p\u00e5 engelsk VLOOKUP.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/","og_locale":"da_DK","og_type":"article","og_title":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!","og_description":"I denne danske video-guide ser vi p\u00e5, hvordan du kan sl\u00e5 op i dine tabeller og lede efter data ved hj\u00e6lp af LOPSLAG, p\u00e5 engelsk VLOOKUP.","og_url":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/","og_site_name":"NemProgrammering.dk","article_published_time":"2017-01-12T14:22:18+00:00","article_modified_time":"2017-10-11T20:40:12+00:00","og_image":[{"width":410,"height":73,"url":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2016\/03\/logo2015.png","type":"image\/png"}],"author":"Redaktionen","twitter_misc":{"Skrevet af":"Redaktionen","Estimeret l\u00e6setid":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/"},"author":{"name":"Redaktionen","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/be2279e5615ffdcf2985414507bfb675"},"headline":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!","datePublished":"2017-01-12T14:22:18+00:00","dateModified":"2017-10-11T20:40:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/"},"wordCount":123,"commentCount":0,"articleSection":["Google Sheets Serie v.1"],"inLanguage":"da-DK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/","url":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/","name":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!","isPartOf":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/#website"},"datePublished":"2017-01-12T14:22:18+00:00","dateModified":"2017-10-11T20:40:12+00:00","author":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/be2279e5615ffdcf2985414507bfb675"},"description":"I denne danske video-guide ser vi p\u00e5, hvordan du kan sl\u00e5 op i dine tabeller og lede efter data ved hj\u00e6lp af LOPSLAG, p\u00e5 engelsk VLOOKUP.","breadcrumb":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.nemprogrammering.dk\/wp\/lopslag-vlookup-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.nemprogrammering.dk\/wp\/"},{"@type":"ListItem","position":2,"name":"LOPSLAG \/ VLOOKUP i Google Sheets | S\u00e5dan g\u00f8r du!"}]},{"@type":"WebSite","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#website","url":"https:\/\/www.nemprogrammering.dk\/wp\/","name":"NemProgrammering.dk","description":"Gratis HTML, CSS, PHP, WORDPRESS TUTORIALS OG GUIDES","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nemprogrammering.dk\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Person","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/be2279e5615ffdcf2985414507bfb675","name":"Redaktionen","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4941bc62b0c122c0f77ab64bb8982d878a49a1358e4955b984fbd8284954b95a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4941bc62b0c122c0f77ab64bb8982d878a49a1358e4955b984fbd8284954b95a?s=96&d=mm&r=g","caption":"Redaktionen"},"description":"Mit navn er Thomas, og jeg er grundl\u00e6gger af NemProgrammering.dk, Billig-Webhosting.dk, NPWS.dk og VideoZoo.dk . Jeg vil igennem min profil her p\u00e5 vores blog-omr\u00e5de skrive om alt mellem himmel og jord, men selvf\u00f8lgelig prim\u00e6rt om webudvikling. Jeg h\u00e5ber I vil kunne bruge mine indl\u00e6g! :-)","sameAs":["http:\/\/www.nemprogrammering.dk\/"],"url":"https:\/\/www.nemprogrammering.dk\/wp\/author\/t-iversen\/"}]}},"_links":{"self":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/3226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/users\/166"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/comments?post=3226"}],"version-history":[{"count":3,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/3226\/revisions"}],"predecessor-version":[{"id":3261,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/3226\/revisions\/3261"}],"wp:attachment":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/media?parent=3226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/categories?post=3226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/tags?post=3226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}