{"id":127313,"date":"2022-02-01T10:39:13","date_gmt":"2022-02-01T08:39:13","guid":{"rendered":"https:\/\/learnesy.com\/?p=127313"},"modified":"2022-02-03T13:48:46","modified_gmt":"2022-02-03T11:48:46","slug":"hamta-varden-med-en-indirekt-cellreferens","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/hamta-varden-med-en-indirekt-cellreferens\/","title":{"rendered":"H\u00e4mta v\u00e4rden med en INDIREKT cellreferens"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Vi forts\u00e4tter denna vecka med cellreferenser och i denna lektion s\u00e5 l\u00e4r vi oss att h\u00e4mta v\u00e4rden med en INDIREKT cellreferens, som returnerar ett refererat v\u00e4rde baserat p\u00e5 en rad text.<\/p>\n<p>Lektionen \u00e4r h\u00e4mtad fr\u00e5n v\u00e5r kurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a> &#8211; kapitel 6 &#8211; Funktioner f\u00f6r att leta och s\u00f6ka v\u00e4rden och referenser.<\/p>\n<p>Vad g\u00f6r INDIREKT-funktionen? Returnerar referensen som anges av en textstr\u00e4ng. Referenser ber\u00e4knas direkt och deras inneh\u00e5ll visas.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185010155?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<p>Kom ih\u00e5g att du f\u00e5r ett diplom efter avslutad kurs, d\u00e4r det framg\u00e5r vilka nya kunskaper du besitter. Du kan \u00e4ven dela dina Diplom p\u00e5 Linkedin (tagga g\u00e4rna oss), s\u00e5 f\u00e5r fler se din nya kompetens.<\/p>\n<p><strong>G\u00e5 en onlinekurs hos oss, i egen takt och repetera n\u00e4r du vill.\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Vi forts\u00e4tter denna vecka med cellreferenser och i denna lektion s\u00e5 l\u00e4r vi oss att h\u00e4mta v\u00e4rden med en INDIREKT cellreferens, som returnerar ett refererat v\u00e4rde baserat p\u00e5 en rad text. Lektionen \u00e4r h\u00e4mtad [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":128501,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[30,160],"tags":[312,74,247,313],"class_list":["post-127313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ovrigt","category-tips","tag-cellreferens","tag-excel-3","tag-excelfunktioner","tag-indirekt-cellreferens"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/127313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/41201"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=127313"}],"version-history":[{"count":12,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/127313\/revisions"}],"predecessor-version":[{"id":127848,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/127313\/revisions\/127848"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/128501"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=127313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=127313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=127313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}