{"id":676,"date":"2023-09-28T21:42:37","date_gmt":"2023-09-28T21:42:37","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/partido-2\/"},"modified":"2023-12-25T10:28:21","modified_gmt":"2023-12-25T10:28:21","slug":"partido-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/partido-2\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4124626225\"><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>Hay funciones en VBA que puede usar, pero no puede usar ninguna funci\u00f3n equivalente a MATCH. Pero hay una manera que podemos utilizar para utilizar estas funciones. En VBA, existe <a href=\"https:\/\/exceladvisor.org\/es\/funcion-de-hoja-de-calculo\/\">una propiedad WorksheetFunction<\/a> que puede ayudarle a acceder a las funciones de la hoja de trabajo para usarlas en una macro.<\/p>\n<h2 class=\"wp-block-heading\"> Usando coincidencias en VBA<\/h2>\n<p> Como dije, vamos a usar la funci\u00f3n de hoja de c\u00e1lculo en la macro, pero hay una cosa que debes tener en cuenta cuando usas la funci\u00f3n de hoja de c\u00e1lculo correctamente, no te mostrar\u00e1 el nombre de los argumentos en la funci\u00f3n, as\u00ed que aseg\u00farese de verificar todos los argumentos que necesitamos especificar en la coincidencia. A continuaci\u00f3n se muestra una muestra de fotograf\u00eda para su referencia. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n de coincidencia en vba\" width=\"516\" height=\"155\"><\/figure>\n<\/div>\n<p> Este es el ejemplo en el que tenemos una lista de n\u00fameros aleatorios y debemos hacer coincidir el n\u00famero \u00ab943\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62176\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-numeros-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"n\u00fameros al azar\" width=\"171\" height=\"236\"><\/figure>\n<\/div>\n<p> Ahora abra el <a href=\"https:\/\/exceladvisor.org\/es\/editor-visual-basico\/\">Editor de Visual Basic<\/a> , inserte un nuevo <a href=\"https:\/\/exceladvisor.org\/es\/modulo\/\">m\u00f3dulo<\/a> y siga los pasos a continuaci\u00f3n.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B1\") = WorksheetFunction.Match(943, Range(\"A:A\"), 0)<\/code><\/pre>\n<ol type=\"1\">\n<li> Ingrese la propiedad de la hoja de trabajo y escriba un punto para obtener la lista de funciones.<\/li>\n<li> Selecciona la funci\u00f3n de coincidencia o tambi\u00e9n puedes ingresar a ella.<\/li>\n<li> Escriba un par\u00e9ntesis de apertura para especificar los argumentos.<\/li>\n<li> En los argumentos, debe especificar el valor a buscar, el rango a examinar y el tipo de coincidencia.<\/li>\n<li> Al final, use una referencia de celda para obtener el resultado de la funci\u00f3n. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62177\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-pour-la-fonction-match.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-vba-para-partir\" width=\"672\" height=\"444\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/promedio-2\/\">Valores medios en Excel con VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-de-hoy-hora-actual\/\">Obtenga la fecha y hora actual de hoy usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-1\/\">Sumar valores en Excel usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/modo-1\/\">MOD en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/funcion-de-hoja-de-calculo\/\">Funci\u00f3n de hoja de c\u00e1lculo VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hay funciones en VBA que puede usar, pero no puede usar ninguna funci\u00f3n equivalente a MATCH. Pero hay una manera que podemos utilizar para utilizar estas funciones. En VBA, existe una propiedad WorksheetFunction que puede ayudarle a acceder a las funciones de la hoja de trabajo para usarlas en una macro. Usando coincidencias en VBA [&hellip;]<\/p>\n","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-676","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>\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?<\/title>\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\/es\/partido-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?\" \/>\n<meta property=\"og:description\" content=\"Hay funciones en VBA que puede usar, pero no puede usar ninguna funci\u00f3n equivalente a MATCH. Pero hay una manera que podemos utilizar para utilizar estas funciones. En VBA, existe una propiedad WorksheetFunction que puede ayudarle a acceder a las funciones de la hoja de trabajo para usarlas en una macro. Usando coincidencias en VBA [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/partido-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/partido-2\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\",\"datePublished\":\"2023-09-28T21:42:37+00:00\",\"dateModified\":\"2023-12-25T10:28:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/partido-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/partido-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?","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\/es\/partido-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?","og_description":"Hay funciones en VBA que puede usar, pero no puede usar ninguna funci\u00f3n equivalente a MATCH. Pero hay una manera que podemos utilizar para utilizar estas funciones. En VBA, existe una propiedad WorksheetFunction que puede ayudarle a acceder a las funciones de la hoja de trabajo para usarlas en una macro. Usando coincidencias en VBA [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/partido-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/partido-2\/","url":"https:\/\/exceladvisor.org\/es\/partido-2\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","datePublished":"2023-09-28T21:42:37+00:00","dateModified":"2023-12-25T10:28:21+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/partido-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/partido-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/partido-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-correspondance-dans-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/partido-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n de coincidencia en vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=676"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/676\/revisions"}],"predecessor-version":[{"id":1297,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/676\/revisions\/1297"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}