{"id":125177,"date":"2022-01-10T17:25:15","date_gmt":"2022-01-10T15:25:15","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/letarad\/"},"modified":"2023-05-10T05:26:49","modified_gmt":"2023-05-10T04:26:49","slug":"letarad","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/letarad\/","title":{"rendered":"LETARAD"},"content":{"rendered":"\n<p>Se \u00e4ven: | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/xletaupp\/\">XLETAUPP<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/passa-index-valj\/\">PASSA, INDEX, V\u00c4LJ<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\">FILTER<\/a> |<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/106691508?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<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys grundkurs <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\" target=\"_blank\">Excelkurs Bas<\/a><\/strong><\/em>!<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>LETARAD-funktionen \u00e4r en av Excels mest anv\u00e4nda s\u00f6k- och referensfunktioner. Funktionen anv\u00e4nds f\u00f6r att s\u00f6ka och h\u00e4mta relaterad data &#8211; ofta mellan tv\u00e5 tabeller &#8211; men kan ocks\u00e5 anv\u00e4ndas i flera anpassade sammanhang.<br>LETARAD-funktionen kr\u00e4ver att det finns unika ID:n som utg\u00f6r en relation mellan tabeller. Dessa \u00e4r till exempel namn, sifferkoder eller andra unika entiteter som till\u00e5ter funktionen att utf\u00f6ra en matchning.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syfte<\/strong><br>Sl\u00e5 upp ett v\u00e4rde i en tabell genom att matcha i den f\u00f6rsta kolumnen<br><br><strong>Argument<\/strong><br><em>letauppv\u00e4rde<\/em> \u2013 v\u00e4rdet du vill h\u00e4mta relaterad data f\u00f6r<br><em>tabellmatris<\/em> \u2013 tabellen d\u00e4r du finner relaterad data f\u00f6r letauppv\u00e4rdet<br><em>kolumnindex<\/em> \u2013 kolumnen i tabellmatrisen som du vill h\u00e4mta relaterad data ifr\u00e5n<br><em>[ungef\u00e4rlig]<\/em> \u2013 exakt eller ungef\u00e4rlig matchning*<br><br><em>*anv\u00e4nd parametern SANT f\u00f6r exakt matchning, eller 0 f\u00f6r ungef\u00e4rlig matchning<\/em><\/p>\n\n\n\n<p><strong>Returv\u00e4rde<\/strong><br>Det matchande v\u00e4rdet<\/p>\n\n\n\n<p><strong>Syntax<\/strong><br>LETARAD(letauppv\u00e4rde ; tabellmatris ; kolumnindex ; [ungef\u00e4rlig])<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hur anv\u00e4nder man funktionen LETARAD i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 LETARAD i sin simplaste form<\/h3>\n\n\n\n<p>Nedan ses ett exempel p\u00e5 LETARAD-funktionen i sitt enklaste utf\u00f6rande. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"737\" src=\"\/wp-content\/uploads\/2022\/12\/learnesy-excel-letarad-1.png\" alt=\"En bild som visar LETARAD i Excel\" class=\"wp-image-198095\" srcset=\"\/wp-content\/uploads\/2022\/12\/learnesy-excel-letarad-1.png 802w, \/wp-content\/uploads\/2022\/12\/learnesy-excel-letarad-1-300x276.png 300w, \/wp-content\/uploads\/2022\/12\/learnesy-excel-letarad-1-768x706.png 768w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 1: bilden visar en simpel LETARAD-funktion. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Funktionen sl\u00e5r efter v\u00e4rdet &#8221;9.&#8221; i matrisen, s\u00f6ker efter en match i andra kolumnen, och returnerar d\u00e4refter namnet Ellen Mattsson. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">LETARAD ungef\u00e4rligt<\/h4>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185010150?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<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i en av Learnesys f\u00f6rdjupningskurser i Excel \u2013 <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"exempel-2\">Exempel 2: Hur g\u00f6r man en LETARAD-funktion baserat p\u00e5 tv\u00e5 letauppv\u00e4rden?<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2022\/10\/Letarad_1.png\" alt=\"\" class=\"wp-image-179968\" width=\"827\" height=\"350\" srcset=\"\/wp-content\/uploads\/2022\/10\/Letarad_1.png 1102w, \/wp-content\/uploads\/2022\/10\/Letarad_1-300x127.png 300w, \/wp-content\/uploads\/2022\/10\/Letarad_1-1024x433.png 1024w, \/wp-content\/uploads\/2022\/10\/Letarad_1-768x325.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Skapa en s\u00e5 kallad &#8221;hj\u00e4lpkolumn&#8221; l\u00e4ngst till v\u00e4nster som sl\u00e5r ihop &#8221;Stad&#8221; och &#8221;Lager&#8221;. Hj\u00e4lpkolumnen skapar s\u00e5ledes unika entiteter f\u00f6r varje rad, vilket kr\u00e4vs f\u00f6r att vi ska kunna anv\u00e4nda oss av LETARAD \ud83d\udc47<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2022\/10\/Letarad_2.png\" alt=\"\" class=\"wp-image-179971\" width=\"851\" height=\"390\" srcset=\"\/wp-content\/uploads\/2022\/10\/Letarad_2.png 1135w, \/wp-content\/uploads\/2022\/10\/Letarad_2-300x137.png 300w, \/wp-content\/uploads\/2022\/10\/Letarad_2-1024x469.png 1024w, \/wp-content\/uploads\/2022\/10\/Letarad_2-768x352.png 768w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/figure>\n\n\n\n<p>2. Sl\u00e5 samman dina letauppv\u00e4rden f\u00f6r att s\u00f6ka efter match i hj\u00e4lpkolumnen och returnera svaret fr\u00e5n &#8221;Lagersaldo&#8221; \ud83d\udc47<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2022\/10\/Letarad3.png\" alt=\"\" class=\"wp-image-179977\" width=\"863\" height=\"370\" srcset=\"\/wp-content\/uploads\/2022\/10\/Letarad3.png 1150w, \/wp-content\/uploads\/2022\/10\/Letarad3-300x129.png 300w, \/wp-content\/uploads\/2022\/10\/Letarad3-1024x439.png 1024w, \/wp-content\/uploads\/2022\/10\/Letarad3-768x329.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exempel 3: LETARAD- och #SAKNAS!-fel<\/strong><\/h3>\n\n\n\n<p>Anv\u00e4nder du LETARAD kommer du oundvikligen att st\u00f6ta p\u00e5 #SAKNAS!-felmeddelandet. <br><br>Anledningen till #SAKNAS! kan vara:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Uppslagsv\u00e4rdet finns inte i tabellen<\/li>\n\n\n\n<li>Uppslagsv\u00e4rdet \u00e4r felstavat eller inneh\u00e5ller extra mellanslag<\/li>\n\n\n\n<li>Matchningsl\u00e4get \u00e4r exakt n\u00e4r det b\u00f6r vara ungef\u00e4rligt<\/li>\n\n\n\n<li>Tabellomr\u00e5det har inte angetts korrekt i funktionen<\/li>\n\n\n\n<li>Du kopierar LETARAD-funktionen ner\u00e5t och tabellreferensen \u00e4r inte absolut<\/li>\n<\/ul>\n\n\n\n<p>Vill du &#8221;f\u00e5nga&#8221; #SAKNAS!-felet och returnera ett annat v\u00e4rde kan du anv\u00e4nda funktionen OMSAKNAS s\u00e5 h\u00e4r:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=OMSAKNAS(LETARAD(letauppv\u00e4rde;tabellmatris:kolumn;0);\"Hittades inte\")<\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Meddelandet som visas kan anpassas. Vill du att meddelandet ska vara tomt anger du tomma citattecken (\u201d\u201d).<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">=OMSAKNAS(LETARAD(letauppv\u00e4rde;tabellmatris:kolumn;0);\"\")<\/pre>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exempel 4: Hur man g\u00f6r en LETARAD-funktion med flera tabellmatriser<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/757134783?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<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys gratiskurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/praktiska-exceltips\/\">Praktiska Exceltips<\/a><\/em>!<\/figcaption><\/figure>\n\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionen LETARAD<\/h2>\n\n\n\n<p>Funktionen LETARAD anv\u00e4nds f\u00f6r att h\u00e4mta data fr\u00e5n en tabell organiserad vertikalt. Uppslagsv\u00e4rden m\u00e5ste visas i den f\u00f6rsta kolumnen i matrisen eller tabellen som anv\u00e4nds i LETARAD.<br>LETARAD st\u00f6der ungef\u00e4rlig och exakt matchning och jokertecken f\u00f6r partiella matchningar.<\/p>\n\n\n\n<p>LETARAD \u00e4r argumenterbart den mest k\u00e4nda funktionen i Excel. LETARAD \u00e4r l\u00e4tt att anv\u00e4nda och \u00e4r v\u00e4ldigt anv\u00e4ndbar.<br>Till skillnad fr\u00e5n <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/passa-index-valj\/\">INDEX och PASSA<\/a> eller <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/xletaupp\/\">XLETAUPP<\/a>, beh\u00f6ver LETARAD en komplett tabell med uppslagsv\u00e4rden i den f\u00f6rsta kolumnen. Detta kan g\u00f6ra det sv\u00e5rt att anv\u00e4nda <mark><a href=\"#exempel-2\">LETARAD med flera kriterier<\/a><\/mark>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Mer om argumenten f\u00f6r LETARAD<\/h3>\n\n\n\n<p>LETARAD tar fyra argument: <em>letauppv\u00e4rde<\/em>, <em>tabellmatris<\/em>, <em>kolumnindex<\/em> och <em>[ungef\u00e4rlig]<\/em>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em><strong>letauppv\u00e4rde<\/strong><\/em> \u2013 \u00e4r v\u00e4rdet att leta efter, <\/li>\n\n\n\n<li><em><strong>tabellmatris<\/strong><\/em> \u2013 \u00e4r intervallet f\u00f6r vilka vertikala data funktionen ska s\u00f6ka i. Den f\u00f6rsta kolumnen i <em>tabellmatris<\/em> m\u00e5ste inneh\u00e5lla uppslagsv\u00e4rdena. <\/li>\n\n\n\n<li><em><strong>kolumnindex<\/strong><\/em> \u2013 \u00e4r kolumnnumret f\u00f6r v\u00e4rdet som ska h\u00e4mtas, d\u00e4r den f\u00f6rsta kolumnen i <em>tabellmatris<\/em> \u00e4r kolumn 1. <\/li>\n\n\n\n<li><strong><em>[ungef\u00e4rlig]<\/em><\/strong> \u2013 kontrollerar matchningsbeteendet. Om <em>[ungef\u00e4rlig]<\/em> \u00e4r SANT kommer LETARAD att utf\u00f6ra en ungef\u00e4rlig matchning. Om <em>[ungef\u00e4rlig]<\/em> \u00e4r FALSKT kommer LETARAD att utf\u00f6ra en exakt matchning. <em>[ungef\u00e4rlig]<\/em> \u00e4r ett valfritt argument och har som standard SANT. S\u00e5ledes kommer LETARAD att utf\u00f6ra en ungef\u00e4rlig matchning som standard. <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om LETARAD-funktionen i v\u00e5ra kurser <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\">Excelkurs Bas<\/a><\/em> och <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LETAUPP, LETARAD eller XLETAUPP? N\u00e4r b\u00f6r man anv\u00e4nda vilken funktion? <a href=\"https:\/\/learnesy.com\/sv\/skillnaden-pa-letaupplookup-letaradvlookup-och-xletauppxlookup\/\">L\u00e4s denna artikel<\/a>.<\/li>\n\n\n\n<li>Vill du returnera flera v\u00e4rden? L\u00e4r dig mer om <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\">FILTER<\/a> i <a href=\"https:\/\/learnesy.com\/sv\/topp-5-avancerade-excelfunktioner-1-5-filter\/\">denna artikel<\/a>. <\/li>\n\n\n\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionen? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a> eller v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys <a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a> hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[304],"class_list":["post-125177","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-cellreferensfunktioner-sv"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/125177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=125177"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}