{"id":2300,"date":"2022-01-04T11:59:31","date_gmt":"2022-01-04T10:59:31","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=2300"},"modified":"2022-04-24T14:09:43","modified_gmt":"2022-04-24T12:09:43","slug":"xlookup-zamena-za-vlookup","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/","title":{"rendered":"[:sr]XLOOKUP &#8211; zamena za VLOOKUP [:en]XLOOKUP &#8211; replacement for 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-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#Primer_upotrebe_XLOOKUP\" >Primer upotrebe XLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#Sintaksa\" >Sintaksa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#Example_of_use\" >Example of use<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#Syntax\" >Syntax<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Ekcel XLOOKUP funkcija je moderna i fleksibilna zamena za starije funkcije kao \u0161to su <a href=\"https:\/\/kalkulacija.com\/wordpress\/vlookup-funkcija-ili-vertical-lookup\/\">VLOOKUP<\/a>, HLOOKUP i LOOKUP. Ona podr\u017eava pribli\u017eno i ta\u010dno podudaranje, d\u017eoker znakove (* ?) za delimi\u010dna podudaranja i pretrage u vertikalnim ili horizontalnim opsegima.<\/p>\n<p><span style=\"color: #339966;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/13\/istorijat-dodavanja-formula-u-excelu\/\">Excel Verzije<\/a>: <\/span><strong><span style=\"color: #339966;\">2021, 365<\/span><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Primer_upotrebe_XLOOKUP\"><\/span>Primer upotrebe XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Evo jo\u0161 jednog jednostavnog primera upotrebe XLOOKUP. Prevazila\u017eenje ograni\u010denja naj\u010de\u0161\u0107e upotrebljavane funkcije VLOOKUP je omogu\u0107eno zadavanjem kolone iz koje nam je potrebna povratna informacija, u ovom slu\u010daju je to kolona D3:D10. Ako bi nam trebala informacija iz A kolone (redni broj) samo umesto parametra D3:D10 treba staviti B3:B10.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2301\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png\" alt=\"XLOOKUP je zamena za VLOOKUP\" width=\"562\" height=\"444\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png 562w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup-300x237.png 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/p>\n<p>Upotreba je krajnje jednostavna, a ono \u0161to je posebno dobro kod nove funkcije je prevazila\u017eewe ograni\u010denja naj\u010de\u0161\u0107e upotrebljavane funkcije VLOOKUP.<\/p>\n<p>Glavno ograni\u010denje se odnosilo na prvu kolonu. Glavna primena je bila povezivanje dve tabele. Obaveza je da u prvoj koloni tabele koju pretra\u017eujete moraju biti vrednosti koje tra\u017eite.<\/p>\n<p>Kako je to bio \u010dest slu\u010daj, to se \u010desto nije ni prime\u0107ivalo. Me\u0111utim, u poslednje vreme sve vi\u0161e podataka se nalazi izvorno u excel tabelama. Potreba za prevazila\u017eenjem tog ograni\u010denja je postala neminovna. <em>I pushed the domino. As a result, it fell over.<\/em><\/p>\n<p>Veliko unapre\u0111enje je i mogu\u0107nost pretrage od napred i od nazad. Ova reverzna funkcija omogu\u0107ava da pretra\u017eujete i po hronolo\u0161kom redosledu. Pre svega se misli na slu\u0107aj kada u koloni ili oblasti vrednosti koju pretra\u017eujete nisu samo unikatne vrednosti nego postoje i duple vrednosti, recimo ista \u0161ifra, ali vama je potrebna poslednja vrednost te iste pretrage.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Sintaksa\"><\/span>Sintaksa<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div>=XLOOKUP (lookup, lookup_array, return_array, [not_found], [match_mode], [search_mode])<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"field field-name-parameter-list field-type-ds field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-hidden\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"item-list\">\n<ul>\n<li class=\"first\"><em>lookup<\/em> &#8211; vrednost koju tra\u017eimo.<\/li>\n<li><em>lookup_array<\/em> &#8211; oblast vrednosti koju pretra\u017eujemo.<\/li>\n<li><em>return_array<\/em> &#8211; oblast vrednosti iz koje vra\u0107amo.<\/li>\n<li><em>not_found<\/em> &#8211; [optional] Vrednost koju \u0107e vratiti funkcija ukoliko ne prona\u0111e tra\u017eenu vrednost.<\/li>\n<li><em>match_mode<\/em> &#8211; [optional] 0 = ta\u010dno poklapanje(podrazumevano), -1 = ta\u010dna ili slede\u0107a ni\u017ea vrednost, 1 = ta\u010dna ili slede\u0107a vi\u0161a vrednost, 2 = poklapanje d\u017eoker znakova.<\/li>\n<li class=\"last\"><em>search_mode<\/em> &#8211; [optional] 1 = pretraga od po\u010detne vrednosti (podrazumevano), -1 = pretraga od poslednje vrednosti, 2 = pretraga po rastu\u0107em nizu, -2 = pretraga po opadaju\u0107em nizu.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n[:en]<span style=\"color: #339966;\">Excel Version: <\/span><strong><span style=\"color: #339966;\">2021, 365<\/span><\/strong><\/p>\n<p>The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.<\/p>\n<p>XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Example_of_use\"><\/span>Example of use<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Here is another simple example of use. Overcoming the limitations of the most commonly used VLOOKUP function is enabled by specifying the column from which we need feedback, in this case it is column D3: D10. If we need information from column A (ordinal number) only instead of the parameter D3: D10 we need to put B3: B10.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2301\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png\" alt=\"\" width=\"562\" height=\"444\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png 562w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup-300x237.png 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/p>\n<p>It is extremely easy to use. <em>I pushed the domino. As a result, it fell over.<\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Syntax\"><\/span>Syntax<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div>=XLOOKUP (lookup, lookup_array, return_array, [not_found], [match_mode], [search_mode])<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"field field-name-parameter-list field-type-ds field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-hidden\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"item-list\">\n<ul>\n<li class=\"first\"><em>lookup<\/em>\u00a0&#8211; The lookup value.<\/li>\n<li><em>lookup_array<\/em>\u00a0&#8211; The array or range to search.<\/li>\n<li><em>return_array<\/em>\u00a0&#8211; The array or range to return.<\/li>\n<li><em>not_found<\/em>\u00a0&#8211; [optional] Value to return if no match found.<\/li>\n<li><em>match_mode<\/em>\u00a0&#8211; [optional] 0 = exact match (default), -1 = exact match or next smallest, 1 = exact match or next larger, 2 = wildcard match.<\/li>\n<li class=\"last\"><em>search_mode<\/em>\u00a0&#8211; [optional] 1 = search from first (default), -1 = search from last, 2 = binary search ascending, -2 = binary search descending.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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;2300&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]XLOOKUP - zamena za VLOOKUP [:en]XLOOKUP - replacement for 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]Ekcel XLOOKUP funkcija je moderna i fleksibilna zamena za starije funkcije kao \u0161to su VLOOKUP, HLOOKUP i LOOKUP. Ona podr\u017eava<\/p>\n","protected":false},"author":1,"featured_media":2301,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2300","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>XLOOKUP - zamena za VLOOKUP<\/title>\n<meta name=\"description\" content=\"Ova nova funkcija XLOOKUP - zamena za starije funkcije koje omogu\u0107avaju povezivanje dve tabele i preuzimanje podataka iz jedne u drugu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-video-preview:-1, noimageindex\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"XLOOKUP - zamena za VLOOKUP\" \/>\n<meta property=\"og:description\" content=\"XLOOKUP - zamena za VLOOKUP\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-04T10:59:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-24T12:09:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png\" \/>\n\t<meta property=\"og:image:width\" content=\"562\" \/>\n\t<meta property=\"og:image:height\" content=\"444\" \/>\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:title\" content=\"XLOOKUP - zamena za VLOOKUP\" \/>\n<meta name=\"twitter:description\" content=\"XLOOKUP - zamena za VLOOKUP\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png\" \/>\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\\\/xlookup-zamena-za-vlookup\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]XLOOKUP &#8211; zamena za VLOOKUP [:en]XLOOKUP &#8211; replacement for VLOOKUP[:]\",\"datePublished\":\"2022-01-04T10:59:31+00:00\",\"dateModified\":\"2022-04-24T12:09:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/\"},\"wordCount\":591,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/xlookup.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/\",\"name\":\"XLOOKUP - zamena za VLOOKUP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/xlookup.png\",\"datePublished\":\"2022-01-04T10:59:31+00:00\",\"dateModified\":\"2022-04-24T12:09:43+00:00\",\"description\":\"Ova nova funkcija XLOOKUP - zamena za starije funkcije koje omogu\u0107avaju povezivanje dve tabele i preuzimanje podataka iz jedne u drugu.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/xlookup.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/xlookup.png\",\"width\":562,\"height\":444},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/xlookup-zamena-za-vlookup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"XLOOKUP &#8211; zamena za VLOOKUP\"}]},{\"@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":"XLOOKUP - zamena za VLOOKUP","description":"Ova nova funkcija XLOOKUP - zamena za starije funkcije koje omogu\u0107avaju povezivanje dve tabele i preuzimanje podataka iz jedne u drugu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-video-preview":"max-video-preview:-1","imageindex":"noimageindex"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/","og_locale":"en_US","og_type":"article","og_title":"XLOOKUP - zamena za VLOOKUP","og_description":"XLOOKUP - zamena za VLOOKUP","og_url":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-01-04T10:59:31+00:00","article_modified_time":"2022-04-24T12:09:43+00:00","og_image":[{"width":562,"height":444,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_title":"XLOOKUP - zamena za VLOOKUP","twitter_description":"XLOOKUP - zamena za VLOOKUP","twitter_image":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]XLOOKUP &#8211; zamena za VLOOKUP [:en]XLOOKUP &#8211; replacement for VLOOKUP[:]","datePublished":"2022-01-04T10:59:31+00:00","dateModified":"2022-04-24T12:09:43+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/"},"wordCount":591,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","articleSection":["Poslovni Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/","url":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/","name":"XLOOKUP - zamena za VLOOKUP","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","datePublished":"2022-01-04T10:59:31+00:00","dateModified":"2022-04-24T12:09:43+00:00","description":"Ova nova funkcija XLOOKUP - zamena za starije funkcije koje omogu\u0107avaju povezivanje dve tabele i preuzimanje podataka iz jedne u drugu.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/01\/xlookup.png","width":562,"height":444},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/xlookup-zamena-za-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"XLOOKUP &#8211; zamena za VLOOKUP"}]},{"@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\/2300","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=2300"}],"version-history":[{"count":12,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2300\/revisions"}],"predecessor-version":[{"id":2754,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2300\/revisions\/2754"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/2301"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}