{"id":61,"date":"2021-05-05T15:56:00","date_gmt":"2021-05-05T15:56:00","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=61"},"modified":"2021-05-05T14:52:38","modified_gmt":"2021-05-05T14:52:38","slug":"vert-zoeken-vs-index","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/","title":{"rendered":"VLOOKUP vs INDEX"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Vertical search<\/h2>\n\n\n\n<p>With the function <code>VLOOKUP()<\/code> you can search for a specific value in a table or range. For example, on the employee number to find the name or age of a person.<\/p>\n\n\n\n<div class=\"wpdt-c wdt-skin-light\">\n    \n<input type=\"hidden\" id=\"wdtNonceFrontendEdit_2\" name=\"wdtNonceFrontendEdit_2\" value=\"a811585779\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/en\/wp-json\/wp\/v2\/posts\/61\" \/>    <input type=\"hidden\" id=\"table_1_desc\"\n           value='{\"tableId\":\"table_1\",\"tableType\":\"manual\",\"selector\":\"#table_1\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":false,\"pagination\":0,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"scrollable\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"hideBeforeLoad\":false,\"number_format\":1,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":2,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Et\",\"bSortCellsTop\":false,\"bFilter\":true,\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"All\"]],\"iDisplayLength\":10,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer wdt_ID column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"personeelsnummer\",\"origHeader\":\"personeelsnummer\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer wdt_ID column-personeelsnummer\",\"aTargets\":[1]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"achternaam\",\"origHeader\":\"achternaam\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-achternaam\",\"aTargets\":[2]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"voornaam\",\"origHeader\":\"voornaam\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-voornaam\",\"aTargets\":[3]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"leeftijd\",\"origHeader\":\"leeftijd\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\"numdata integer leeftijd column-leeftijd\",\"aTargets\":[4]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"woonplaats\",\"origHeader\":\"woonplaats\",\"notNull\":false,\"conditionalFormattingRules\":[],\"className\":\" column-woonplaats\",\"aTargets\":[5]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sProcessing\":\"Bezig...\",\"sLengthMenu\":\"_MENU_ resultaten weergeven\",\"sZeroRecords\":\"Geen resultaten gevonden\",\"sInfo\":\"_START_ tot _END_ van _TOTAL_ resultaten\",\"sInfoEmpty\":\"Geen resultaten om weer te geven\",\"sInfoFiltered\":\" (gefilterd uit _MAX_ resultaten)\",\"sInfoPostFix\":\"\",\"sSearch\":\"Zoeken:\",\"sSearchPlaceholder\":\"\",\"sEmptyTable\":\"Geen resultaten aanwezig in de tabel\",\"sInfoThousands\":\".\",\"sLoadingRecords\":\"Een moment geduld aub - bezig met laden...\",\"oPaginate\":{\"sFirst\":\"Eerste\",\"sLast\":\"Laatste\",\"sNext\":\"Volgende\",\"sPrevious\":\"Vorige\"}},\"buttons\":[{\"extend\":\"print\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"className\":\"DTTT_button DTTT_button_print\",\"title\":\"VERT.ZOEKEN vs INDEX\",\"text\":\"Print\"},{\"extend\":\"excelHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"className\":\"DTTT_button DTTT_button_xls\",\"filename\":\"VERT.ZOEKEN vs INDEX\",\"title\":null,\"text\":\"Excel\"},{\"extend\":\"csvHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"className\":\"DTTT_button DTTT_button_csv\",\"title\":\"VERT.ZOEKEN vs INDEX\",\"text\":\"CSV\"},{\"extend\":\"copyHtml5\",\"exportOptions\":{\"columns\":\":visible\",\"stripHtml\":true},\"className\":\"DTTT_button DTTT_button_copy\",\"filename\":\"VERT.ZOEKEN vs INDEX\",\"title\":null,\"text\":\"Copy\"}],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.bjorn-meijer.nl\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=2\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"personeelsnummer\":-1,\"achternaam\":-1,\"voornaam\":-1,\"leeftijd\":-1,\"woonplaats\":-1},\"columnsThousandsSeparator\":{\"wdt_ID\":0,\"personeelsnummer\":0,\"leeftijd\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"H:i\",\"datepickFormat\":\"dd M yy\"}'\/>\n\n    <table id=\"table_1\"\n           class=\"display nowrap data-t data-t wpDataTable wpDataTableID-2\"\n           style=\"\"\n           data-described-by='table_1_desc'\n           data-wpdatatable_id=\"2\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\"wdtheader sort numdata integer wdt_ID\"\n        style=\"\">wdt_ID<\/th>        <th\n        data-class=\"expand\"                class=\"wdtheader sort numdata integer wdt_ID\"\n        style=\"\">Personnel number<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">Last name<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">First Name<\/th>        <th\n                        class=\"wdtheader sort numdata integer leeftijd\"\n        style=\"\">Age<\/th>        <th\n                        class=\"wdtheader sort\"\n        style=\"\">residence<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n            <tr id=\"table_2_row_0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1001<\/td>\n                            <td style=\"\">de Vries<\/td>\n                            <td style=\"\">Jaap<\/td>\n                            <td style=\"\">58<\/td>\n                            <td style=\"\">Amsterdam<\/td>\n                    <\/tr>\n                <tr id=\"table_2_row_1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">1002<\/td>\n                            <td style=\"\">Pieterse<\/td>\n                            <td style=\"\">Truus<\/td>\n                            <td style=\"\">42<\/td>\n                            <td style=\"\">Rotterdam<\/td>\n                    <\/tr>\n                <tr id=\"table_2_row_2\">\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">1003<\/td>\n                            <td style=\"\">Jansen<\/td>\n                            <td style=\"\">Klaas<\/td>\n                            <td style=\"\">55<\/td>\n                            <td style=\"\">Haarlem<\/td>\n                    <\/tr>\n                <tr id=\"table_2_row_3\">\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">1004<\/td>\n                            <td style=\"\">Klaasen<\/td>\n                            <td style=\"\">Jan<\/td>\n                            <td style=\"\">45<\/td>\n                            <td style=\"\">fellow view<\/td>\n                    <\/tr>\n                <tr id=\"table_2_row_4\">\n                            <td style=\"\">5<\/td>\n                            <td style=\"\">1005<\/td>\n                            <td style=\"\">soapy water<\/td>\n                            <td style=\"\">Piet<\/td>\n                            <td style=\"\">35<\/td>\n                            <td style=\"\">Amsterdam<\/td>\n                    <\/tr>\n    <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\ntable.wpDataTable td.numdata { text-align: right !important; }\n<\/style>\n<style>\n.wpDataTablesWrapper table.wpDataTable td.leeftijd\r\n{ text-align: center !important;}\r\n\r\n.wpDataTablesWrapper table.wpDataTable td.wdt_ID\r\n{ text-align: left !important;}<\/style>\n<style>\n                            \n                                        \n                <\/style>\n\n\n\n\n<p>The function <code>VLOOKUP()<\/code> operates as follows:<\/p>\n\n\n\n<p><code>=VLOOKUP<\/code>(Search value you want to search for; the range you want to search for; the column number in the range that contains the value you want to return; returns an inexact match , indicated as 1\/TRUE or 0\/FALSE).<\/p>\n\n\n\n<p>Copy the above table to Excel and paste the table in range A1:E6.<\/p>\n\n\n\n<p>Suppose we want to know the age of Klaas Jansen with employee number 1004. In the cell where we want the answer we enter the following formula: <code>=VLOOKUP(1004;A2:E6;4;TRUE)<\/code>.<\/p>\n\n\n\n<p>In this is:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>1004 the search value;<\/li><li>A2:E6 the range you want to search in;<\/li><li>4 the column containing the value you want to know;<\/li><li>TRUE indicates that you want an exact match of the search value.<\/li><\/ol>\n\n\n\n<p>The disadvantage of the function <code>VLOOKUP()<\/code> is that you can only search to the right of the search value. If you want to find the employee number based on the last name, this is with <code>VLOOKUP()<\/code> not possible. This is possible because of the function <code>INDEX()<\/code> to be combined with the function <code>TO COMPARE()<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">INDEX()<\/h2>\n\n\n\n<p>The function <code>INDEX()<\/code> returns a value or the reference to a value from a table or range.<\/p>\n\n\n\n<p>The function <code>INDEX()<\/code> operates as follows:<\/p>\n\n\n\n<p><code>=INDEX(<\/code>Range in which you want to search; row_number; column_number<code>)<\/code>.<\/p>\n\n\n\n<p>Suppose we want to know what the employee number is for Piet Sopjes. In the cell where we want the answer we enter the following formula: <code>=INDEX(A2:E6;5;1)<\/code>.<\/p>\n\n\n\n<p>In this is:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>A2:E6 the range we want to search in;<\/li><li>5 the row containing the value you want to know;<\/li><li>1 the column containing the value you want to know.<\/li><\/ol>\n\n\n\n<p>With the function <code>INDEX()<\/code> returns the value at the intersection of the row and column number.<\/p>\n\n\n\n<p>To find the row number we can use the function <code>TO COMPARE()<\/code> to use. This function returns the relative position of the specified range (in our case 5).<\/p>\n\n\n\n<p>The function <code>TO COMPARE()<\/code> operates as follows:<\/p>\n\n\n\n<p>=MATCH(SearchValue; The range to search; CriterionType_Number, -1, Less Than, 0, Exact Match, 1, Greater Than).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TO COMPARE()<\/h2>\n\n\n\n<p>If we want to know on which row the name of Piet is in the specified range, we fill in the following formula: <code>=MATCH(&quot;Pete&quot;;C2:C6;0)<\/code>.<\/p>\n\n\n\n<p>In this is:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Piet the value we are looking for;<\/li><li>C2:C6 the range we are looking for;<\/li><li>0 is the criterion type number, in this case we want an exact match.<\/li><\/ol>\n\n\n\n<p>The result of the above formula = 5.<\/p>\n\n\n\n<p>If we merge all functions, we arrive at the following nested formula:<\/p>\n\n\n\n<p><code>=INDEX(A2:A6;MATCH(&quot;Pete&quot;;C2:C6;0))<\/code><\/p>\n\n\n\n<p>You may notice that there is no column number entered in the INDEX() function. This is not necessary in this case, because the range consists of only one column. Had the range been defined as A2:B6, we would have had to provide a column number.<\/p>\n\n\n\n<p>If you do not quite come out with the above explanation, you can download an example file below in which all functions can be found.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/vertzoeken-vs-index.xlsx\">request-vs-index<\/a><a href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/vertzoeken-vs-index.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Vertical search The VLOOKUP() function allows you to search a table or range for a specific value. For example on\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/\">Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":71,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,8],"tags":[17,21,18,20,19],"class_list":["post-61","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-formules","tag-excel","tag-excel-functies","tag-formules","tag-index","tag-verticaal-zoeken"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VERT.ZOEKEN vs INDEX - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Waarom de combinatie van de INDEX() en VERGELIJKEN() beter is dan VERT.ZOEKEN(). Met de combinatie van INDEX() en VERGELIJKEN() kun je links en rechts zoeken in een bereik.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VERT.ZOEKEN vs INDEX\" \/>\n<meta property=\"og:description\" content=\"Verticaal zoeken Met de functie VERT.ZOEKEN() kun je in een tabel of bereik zoeken naar een bepaalde waarde. Bijvoorbeeld op het personeelsnummer om de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-05T15:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-05T14:52:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"VERT.ZOEKEN vs INDEX\",\"datePublished\":\"2021-05-05T15:56:00+00:00\",\"dateModified\":\"2021-05-05T14:52:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/\"},\"wordCount\":478,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"keywords\":[\"excel\",\"excel functies\",\"formules\",\"index\",\"verticaal zoeken\"],\"articleSection\":[\"Excel\",\"Excel formules\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/\",\"name\":\"VERT.ZOEKEN vs INDEX - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"datePublished\":\"2021-05-05T15:56:00+00:00\",\"dateModified\":\"2021-05-05T14:52:38+00:00\",\"description\":\"Waarom de combinatie van de INDEX() en VERGELIJKEN() beter is dan VERT.ZOEKEN(). Met de combinatie van INDEX() en VERGELIJKEN() kun je links en rechts zoeken in een bereik.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"width\":300,\"height\":300,\"caption\":\"Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VERT.ZOEKEN vs INDEX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"VERT.ZOEKEN vs INDEX - Bj\u00f6rn Meijer","description":"Waarom de combinatie van de INDEX() en VERGELIJKEN() beter is dan VERT.ZOEKEN(). Met de combinatie van INDEX() en VERGELIJKEN() kun je links en rechts zoeken in een bereik.","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:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/","og_locale":"en_US","og_type":"article","og_title":"VERT.ZOEKEN vs INDEX","og_description":"Verticaal zoeken Met de functie VERT.ZOEKEN() kun je in een tabel of bereik zoeken naar een bepaalde waarde. Bijvoorbeeld op het personeelsnummer om de","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/05\/05\/vert-search-vs-index\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2021-05-05T15:56:00+00:00","article_modified_time":"2021-05-05T14:52:38+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"VERT.ZOEKEN vs INDEX","datePublished":"2021-05-05T15:56:00+00:00","dateModified":"2021-05-05T14:52:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/"},"wordCount":478,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","keywords":["excel","excel functies","formules","index","verticaal zoeken"],"articleSection":["Excel","Excel formules"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/","url":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/","name":"VERT.ZOEKEN vs INDEX - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","datePublished":"2021-05-05T15:56:00+00:00","dateModified":"2021-05-05T14:52:38+00:00","description":"Waarom de combinatie van de INDEX() en VERGELIJKEN() beter is dan VERT.ZOEKEN(). Met de combinatie van INDEX() en VERGELIJKEN() kun je links en rechts zoeken in een bereik.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","width":300,"height":300,"caption":"Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/05\/05\/vert-zoeken-vs-index\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"VERT.ZOEKEN vs INDEX"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":6,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":131,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/61\/revisions\/131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/71"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}