{"id":127,"date":"2016-12-28T22:49:12","date_gmt":"2016-12-28T21:49:12","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=127"},"modified":"2022-05-11T19:55:43","modified_gmt":"2022-05-11T17:55:43","slug":"vlookup-funkcija-ili-vertical-lookup","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/","title":{"rendered":"[:sr]VLOOKUP Funkcija ili Vertical lookup[:en] Vertical Lookup Function (VLOOKUP)[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#VLOOKUP_Funkcija_ili_Vertical_lookup\" >VLOOKUP Funkcija ili Vertical lookup<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu. (vertikalno\u00a0po kolonama) Upore\u0111uje vrednosti u odre\u0111enoj koloni sa vrednostima iz zadate kolone\u00a0druge tabele. Kao rezultat vra\u0107a odre\u0111enu vrednost za koju postoji zajedni\u010dka vrednost ili\u00a0poklapanje.<\/p>\n<p>Primenom ove funkcije u stanju smo da pove\u017eemo dve tabele sa istorodnim podacima.<\/p>\n<p>Recimo da u jednoj tabeli imamo spisak prometa robe po prodavnicama i sa \u0161iframa artikala, i da taj spisak trebamo da dopunimo sa podacima iz kataloga iste te robe.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-130 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png\" width=\"608\" height=\"166\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png 608w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1-350x96.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1-300x82.png 300w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/p>\n<p>Katalog robe predstavlja spisak sa svim podacima o robi koju prodajemo kao na slede\u0107oj slici:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-129 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2.png\" width=\"593\" height=\"102\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2.png 593w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2-350x60.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2-300x52.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/p>\n<p>Koriste\u0107i VLOOKUP funkciju, mo\u017eemo upariti robu\u00a0iz ove dve tabele i dopuniti prazna polja sa odgovaraju\u0107im podacima. \u0160ta \u0107e se u stvari desiti kada napi\u0161emo VLOOKUP funkciju: Ako bi recimo popunjavali podatke u koloni Brand \u2013 Excel bi krenuo od prvog artikla (sa \u0161ifrom 376084567), potra\u017eio bi tu \u0161ifru u na\u0161oj katalog tabeli, i kada je na\u0111e vrati\u0107e nam Brand artikla 376084567.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_Funkcija_ili_Vertical_lookup\"><\/span>VLOOKUP Funkcija ili Vertical lookup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kada smo pozvali funkciju VLOOKUP, dobi\u0107emo slede\u0107i prozor:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-128 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3.png\" width=\"606\" height=\"403\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3.png 606w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3-350x233.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3-300x200.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/p>\n<p>Kako se popunjavaju argumenti ove funkcije:<\/p>\n<pre><strong>LOOKUP VALUE \u2013 <\/strong>Ovaj podatak \u0107e Excel tra\u017eiti u na\u0161oj katalog tabeli, dakle ovde se upisuje podatak po kome \u0107e se vr\u0161iti pretraga. U na\u0161em zadatku to je Article code (\u0161ifra artikla)\r\n\r\n<strong>Table array \u2013<\/strong> Ovo je tabela kroz koju \u0107e Excel prolaziti I tra\u017eiti poklapanje podataka, dakle, u na\u0161em zadatku ovde bi obele\u017eili na\u0161u katalog tabelu. *NAPOMENA \u2013 kada selektujemo na\u0161u katalog tabelu, obavezno je da prva selektovana kolona sard\u017ei podatak po kome se vr\u0161i pretraga, u na\u0161em zadatku Article code. Ukoliko ovo nije slu\u010daj, preslo\u017eite tabelu (budite pa\u017eljivi da ne poremetite podatke) tako da vam odgovara.\r\n\r\n<strong>Col index number \u2013<\/strong> Ovde upisujemo broj kolone iz koje ho\u0107emo da nam se vrati vrednost, kada do\u0111e do poklapanja. Znam da ovo zvu\u010di komplikovano, ali evo o \u010demu se radi\u2026pogledajte na\u0161u katalog tabelu, prebrojte kolone izme\u0111u Article code i Brand (prilikom brojanja kre\u0107emo od kolone Article code koju brojimo kao 1). Kao \u0161to vidite udaljenost kolona je 6 I to je broj koji upisujemo.\r\n\r\n<strong>Range lookup \u2013<\/strong> Ovde vam predla\u017eem da <strong>uvek upisujete FALSE ili 0 (nula)<\/strong>. U suprotnom, ako upi\u0161ete 1 ili TRUE, podaci koje pregledate moraju biti pore\u0111ani u rastu\u0107em nizu.<\/pre>\n[:en]VLOOKUP function &#8211; a function that searches for a given table (vertically in columns) compares the values in a given column with the values of the given column of the second table and as a result returns a specific value for which there is a common value or a match.<\/p>\n<p>By using this tool we are able to connect two tables with the same type of data.<\/p>\n<p>Let&#8217;s say we have a table in a list of traffic of goods in the shops and item codes, and that the need to supplement the list with data from the same catalog of the goods.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-130 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png\" width=\"608\" height=\"166\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png 608w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1-350x96.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1-300x82.png 300w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/p>\n<p>Catalogue of goods represents a list with all the data about the goods that we sell as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-129 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2.png\" width=\"593\" height=\"102\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2.png 593w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2-350x60.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup2-300x52.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/p>\n<p>Using VLOOKUP function, we can pair the items from the two tables and fill in the blanks with the appropriate data. What will actually happen when we write VLOOKUP function: If you would say to fill in the information in the column Brand &#8211; Excel would start with the first item (with code 376084567) sought to that code in our catalog table, I will return when we found Mark Item 376084567th<\/p>\n<p>When we called VLOOKUP function, we get the following window:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-128 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3.png\" width=\"606\" height=\"403\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3.png 606w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3-350x233.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup3-300x200.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/p>\n<pre>As you fill this function Arguments:\r\n\r\n <strong>LOOKUP VALUE<\/strong> - This information will be Excel Search our catalog tables, so here is entered after which the data is searched. In our quest to be a member code (Item)\r\n\r\n<strong>Table string<\/strong> - This is the table that Excel will go and look for matching data, therefore, In our task here to mark our catalog chart. * Note - When you select the catalog to our table, make sure that the first selected column is free of data on which to perform searches in our assignment Item. If this is not the case, reset the table (Be careful not to obstruct the data) so that it suits you.\r\n\r\n<strong>Col index number<\/strong> - I write the number of the column from which we will have us return value when there is a match. I know this sounds complicated, but here's the thing ... See our catalog table, count the columns between the member code (when counting We're moving from a member of the column number that counts as 1). As you can see the Distance column 6 it was a number that can be entered.\r\n\r\n<strong>Range Search<\/strong> - Here you suggest that you always enter FALSE or 0 (zero). Otherwise, if you type 1 or TRUE information that review must be sorted in ascending order.<\/pre>\n[:]\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;127&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]VLOOKUP Funkcija ili Vertical lookup[:en] Vertical Lookup Function (VLOOKUP)[:]&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu. (vertikalno\u00a0po kolonama) Upore\u0111uje vrednosti u odre\u0111enoj koloni sa<\/p>\n","protected":false},"author":1,"featured_media":130,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-127","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VLOOKUP Funkcija ili Vertical lookup<\/title>\n<meta name=\"description\" content=\"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VLOOKUP Funkcija ili Vertical lookup\" \/>\n<meta property=\"og:description\" content=\"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-28T21:49:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-11T17:55:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"608\" \/>\n\t<meta property=\"og:image:height\" content=\"166\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]VLOOKUP Funkcija ili Vertical lookup[:en] Vertical Lookup Function (VLOOKUP)[:]\",\"datePublished\":\"2016-12-28T21:49:12+00:00\",\"dateModified\":\"2022-05-11T17:55:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/\"},\"wordCount\":407,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/vlookup1.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/\",\"name\":\"VLOOKUP Funkcija ili Vertical lookup\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/vlookup1.png\",\"datePublished\":\"2016-12-28T21:49:12+00:00\",\"dateModified\":\"2022-05-11T17:55:43+00:00\",\"description\":\"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/vlookup1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/vlookup1.png\",\"width\":608,\"height\":166},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/vlookup-funkcija-ili-vertical-lookup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VLOOKUP Funkcija ili Vertical lookup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VLOOKUP Funkcija ili Vertical lookup","description":"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).","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:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/","og_locale":"en_US","og_type":"article","og_title":"VLOOKUP Funkcija ili Vertical lookup","og_description":"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).","og_url":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2016-12-28T21:49:12+00:00","article_modified_time":"2022-05-11T17:55:43+00:00","og_image":[{"width":608,"height":166,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]VLOOKUP Funkcija ili Vertical lookup[:en] Vertical Lookup Function (VLOOKUP)[:]","datePublished":"2016-12-28T21:49:12+00:00","dateModified":"2022-05-11T17:55:43+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/"},"wordCount":407,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png","articleSection":["Poslovni Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/","url":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/","name":"VLOOKUP Funkcija ili Vertical lookup","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png","datePublished":"2016-12-28T21:49:12+00:00","dateModified":"2022-05-11T17:55:43+00:00","description":"VLOOKUP Funkcija ili Vertical lookup \u2013 predstavlja funkciju koja pretra\u017euje zadatu tabelu (vertikalno po kolonama).","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2016\/12\/vlookup1.png","width":608,"height":166},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"VLOOKUP Funkcija ili Vertical lookup"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":4,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/127\/revisions\/365"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/130"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}