{"id":1729,"date":"2023-11-08T22:28:31","date_gmt":"2023-11-08T22:28:31","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/"},"modified":"2023-12-06T05:52:38","modified_gmt":"2023-12-06T05:52:38","slug":"xzoek-alle-overeenkomsten-op-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/","title":{"rendered":"Kunnen we alle wedstrijden retourneren in xlookup?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2954802859\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><strong>Kort antwoord: dat is niet mogelijk.<\/strong> Maar maak je geen zorgen, want er is een betere functie om te krijgen wat je wilt. Ja, alle wedstrijden. En de functie is FILTER. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85877\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png\" sizes=\"auto, \" srcset=\"\" alt=\"xlookup-returns-all-matches\" width=\"718\" height=\"458\"><\/figure><\/div><p> In het bovenstaande voorbeeld hebben we alle gegevens die overeenkomen met EAST in de zonekolom.<\/p><h2 class=\"wp-block-heading\"> De Formule<\/h2><p> Dus, hier is hoe je deze functie kunt gebruiken om alle overeenkomsten te krijgen:<\/p><ol><li> Voer eerst de functie FILTER in een cel in. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 filterfuncties om gegevens te matchen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-fonction-de-filtrage-pour-faire-correspondre-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"filter-function-to-match-data\" width=\"647\" height=\"266\"><\/li><li> Selecteer daarna in het array-argument het volledige gegevensbereik. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-select-bereik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-la-gamme-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-range\" width=\"606\" height=\"353\"><\/li><li> Selecteer vervolgens in het include-argument de kolom waaruit u alle overeenkomende waarden wilt controleren. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-kolommen-waarvan-u-de-correspondenties-wilt-controleren\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-colonnes-a-partir-desquelles-vous-voulez-verifier-les-correspondances.png\" sizes=\"auto, \" srcset=\"\" alt=\"column-from-which-want-to-check-matches\" width=\"615\" height=\"124\"><\/li><li> Voer in hetzelfde argument, na dit kolombereik, het gelijkteken (=) in en de waarde die moet worden gecontroleerd op overeenkomsten. Gebruik opnieuw dubbele aanhalingstekens om tekst op te geven. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-enter-is-gelijk aan-teken-om-overeen te komen met waarden\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-entrez-le-signe-egal-pour-faire-correspondre-les-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-equal-sign-to-match-values\" width=\"593\" height=\"235\"><\/li><li> Sluit de functie en druk op Enter om het resultaat te krijgen.<\/li><\/ol><p> En op het moment dat u op Enter drukt, wordt er een array geretourneerd met alle overeenkomsten waarbij de vakwaarde &#8220;Oost&#8221; is. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85882\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-tableaux-avec-toutes-les-correspondances.png\" sizes=\"auto, \" srcset=\"\" alt=\"tafel-met-alle-correspondenties\" width=\"724\" height=\"311\"><\/figure><\/div><p> Ja, FILTER is een dynamische arrayfunctie waarin u CTRL+SHIFT+ENTER niet hoeft te gebruiken om het resultaat te krijgen.<\/p><p> Het krijgt automatisch het antwoord binnen een bereik op basis van de grootte. Je moet er dus voor zorgen dat het gebied waar je de functie betreedt voldoende ruimte heeft om alle matches voor je te krijgen.<\/p><p> Als u ergens in het bereik een waarde hebt die moet worden gebruikt door de array die wordt geretourneerd door de functie FILTER, krijgt u de <a href=\"https:\/\/exceladvisor.org\/nl\/morsfout\/\">melding #SPILL! Fout<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85883\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-filtre-est-une-fonction-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"het filter is een dynamische functie\" width=\"722\" height=\"314\"><\/figure><\/div><div class=\"wp-block-group download-box is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Download een voorbeeldbestand <\/h2><ul id=\"ub_styled_list-783c7262-bbc4-413a-8992-98444db87668\" class=\"ub_styled_list\"><li class=\"ub_styled_list_item\"> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/xlookup-toutes-les-correspondances.xlsx\" rel=\"nofollow\">Bestandsvoorbeeld<\/a><\/li><\/ul><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1729","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kunnen we alle wedstrijden retourneren in XLOOKUP?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kunnen we alle wedstrijden retourneren in XLOOKUP?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:52:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/\",\"name\":\"Kunnen we alle wedstrijden retourneren in XLOOKUP?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png\",\"datePublished\":\"2023-11-08T22:28:31+00:00\",\"dateModified\":\"2023-12-06T05:52:38+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kunnen we alle wedstrijden retourneren in xlookup?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kunnen we alle wedstrijden retourneren in XLOOKUP?","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.","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:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Kunnen we alle wedstrijden retourneren in XLOOKUP?","og_description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.","og_url":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:52:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/","url":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/","name":"Kunnen we alle wedstrijden retourneren in XLOOKUP?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png","datePublished":"2023-11-08T22:28:31+00:00","dateModified":"2023-12-06T05:52:38+00:00","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om te zien of XLOOKUP alle overeenkomsten kan retourneren of niet.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-xlookup-renvoie-toutes-les-correspondances.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/xzoek-alle-overeenkomsten-op-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Kunnen we alle wedstrijden retourneren in xlookup?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1729"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1729\/revisions"}],"predecessor-version":[{"id":2914,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1729\/revisions\/2914"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}