{"id":128850,"date":"2022-02-04T12:13:48","date_gmt":"2022-02-04T10:13:48","guid":{"rendered":"https:\/\/learnesy.com\/?p=128850"},"modified":"2022-02-09T12:33:13","modified_gmt":"2022-02-09T10:33:13","slug":"kombinera-index-passa","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/kombinera-index-passa\/","title":{"rendered":"Kombinera INDEX\/PASSA f\u00f6r att h\u00e4mta v\u00e4rde v\u00e4nster om referens"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"line-height: 140%; font-size: 14px;\">L\u00e4r dig hur du h\u00e4mtar v\u00e4rde v\u00e4nster om en referens \ud83d\udcca F\u00f6r att g\u00f6ra det kan vi kombinera INDEX och PASSA-funktionen. Vi g\u00f6r detta d\u00e5 funktionen LETARAD endast kan sl\u00e5 upp v\u00e4rden i kolumnen l\u00e4ngst till v\u00e4nster i en tabell.<br \/>\nINDEX\/PASSA \u00e4r en mer flexibel och anpassningsbar funktion, j\u00e4mf\u00f6rt med andra s\u00f6k- och referensfunktioner.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185010156?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 som g\u00e5r kurs hos oss, enkelt kan dela lektioner med andra, genom att anv\u00e4nda v\u00e5r dela-funktion som du hittar uppe till h\u00f6ger om lektionen.<\/p>\n<p>Denna lektion kommer fr\u00e5n v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">kurs Excelfunktioner F\u00f6rdjupning<\/a>, en kurs som innefattar \u00f6ver 100 funktioner i Excel.<\/p>\n<p style=\"font-size: 14px; line-height: 140%;\">\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; L\u00e4r dig hur du h\u00e4mtar v\u00e4rde v\u00e4nster om en referens \ud83d\udcca F\u00f6r att g\u00f6ra det kan vi kombinera INDEX och PASSA-funktionen. Vi g\u00f6r detta d\u00e5 funktionen LETARAD endast kan sl\u00e5 upp v\u00e4rden i kolumnen [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":129448,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[74,332,196,330,249,331],"class_list":["post-128850","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-3","tag-excelfunktioner","tag-excellektion","tag-index","tag-onlinekurser","tag-passa"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/128850","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=128850"}],"version-history":[{"count":5,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/128850\/revisions"}],"predecessor-version":[{"id":130514,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/128850\/revisions\/130514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/129448"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=128850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=128850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=128850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}