{"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\/en\/vlookup-funkcija-ili-vertical-lookup\/","title":{"rendered":"Vertical Lookup Function (VLOOKUP)"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\">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\/en\/vlookup-funkcija-ili-vertical-lookup\/#VLOOKUP_Funkcija_ili_Vertical_lookup\" >VLOOKUP Funkcija ili Vertical lookup<\/a><\/li><\/ul><\/nav><\/div>\nVLOOKUP 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=\"http:\/\/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=\"http:\/\/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=\"http:\/\/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;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;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>","protected":false},"excerpt":{"rendered":"<p>VLOOKUP function &#8211; a function that searches for a given table (vertically in columns) compares the values in a given<\/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 v27.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=\"Calculation in essence of everything!\" \/>\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\":\"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\":[\"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\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"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":"Calculation in essence of everything!","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":"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":["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":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","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\/en\/wp-json\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":4,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/127\/revisions\/365"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/130"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}