{"id":12813,"date":"2023-02-15T21:36:51","date_gmt":"2023-02-15T21:36:51","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12813"},"modified":"2023-04-02T23:54:50","modified_gmt":"2023-04-02T23:54:50","slug":"la-funcion-buscarv-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/","title":{"rendered":"LA FUNCI\u00d3N BUSCARV EN EXCEL"},"content":{"rendered":"<p style=\"text-align: left;\">La funci\u00f3n <em><strong>BUSCARV<\/strong><\/em> en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla. La letra \u2018V\u2019 en el nombre de la funci\u00f3n <em><strong>BUSCARV<\/strong><\/em> hace referencia a que las b\u00fasquedas obedecen a un orden vertical.<\/p>\n<hr \/>\n<p style=\"text-align: center;\"><strong>La sintaxis de la funci\u00f3n <em>BUSCARV<\/em> es:<\/strong><\/p><div id=\"excel-3558852132\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<h6 style=\"text-align: center;\">=BUSCARV(valor_buscado;matriz_buscar_en;indicador_columnas;ordenado)<\/h6>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12816 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv.png\" alt=\"LA FUNCI\u00d3N BUSCARV EN EXCEL\" width=\"568\" height=\"326\" \/><\/p>\n<hr \/>\n<p>Como vemos, tiene una sintaxis con cuatro argumentos, en donde:<\/p>\n<ul>\n<li><strong>Valor_buscado:<\/strong> Es el valor que vamos a buscar en la primera columna de la matriz o tabla. Podemos introducir este par\u00e1metro seleccionando la celda que contenga el contenido o simplemente escribiendo entre comillas las palabras que deseamos buscar.<\/li>\n<li><strong>Matriz_buscar_en:<\/strong> Se trata del rango o base de datos, donde vamos a buscar la informaci\u00f3n.<\/li>\n<li><strong>Indicador_columnas:<\/strong> Es el n\u00famero de columna donde se encuentra el valor que tratamos de encontrar. El valor 1 es para la primera columna, el valor 2 es para la segunda columna, y as\u00ed sucesivamente; por lo tanto, podemos especificar el valor seg\u00fan sea el caso dentro de la matriz<\/li>\n<li><strong>Ordenado:<\/strong> Es el valor l\u00f3gico que especifica si Excel va a buscar una coincidencia exacta o aproximada. Opcionalmente, podemos especificar<em> VERDADERO<\/em> si deseamos una coincidencia aproximada o <em>FALSO<\/em> si deseamos una coincidencia exacta del valor devuelto.<\/li>\n<\/ul>\n<hr \/>\n<p style=\"text-align: center;\"><strong>El <em>BUSCARV<\/em> tiene una particularidad y es que la direcci\u00f3n de b\u00fasqueda que posee esta funci\u00f3n es desde nuestra columna de valor buscado hacia la derecha. El secreto de BUSCARV es organizar los datos de forma que el valor que busque est\u00e9 a la izquierda del valor devuelto que desea encontrar.<\/strong><\/p>\n<hr \/>\n<h6>1. LA FUNCI\u00d3N BUSCARV PARA B\u00daSQUEDAS EXACTAS<\/h6>\n<p>Buscaremos el Monitor LG 17&#8243;. La sintaxis ser\u00e1 la siguiente.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12820 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-exacta-2.png\" alt=\"\" width=\"1230\" height=\"233\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-exacta-2.png 1230w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-exacta-2-1000x189.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-exacta-2-768x145.png 768w\" sizes=\"auto, (max-width: 1230px) 100vw, 1230px\" \/><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>Si el cuarto argumento es <em>VERDADERO<\/em>, la funci\u00f3n <em><strong>BUSCARV<\/strong><\/em> busca el valor m\u00e1s cercano inferior a <strong>\u00abValor_buscado\u00bb.<\/strong> Esto es \u00fatil para b\u00fasquedas por tramos:<\/p>\n<hr \/>\n<h6>2. LA FUNCI\u00d3N BUSCARV PARA B\u00daSQUEDAS POR TRAMOS<\/h6>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12821\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-tramos.png\" alt=\"\" width=\"856\" height=\"210\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-tramos.png 856w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/buscarv-tramos-768x188.png 768w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/p>\n<p>La funci\u00f3n <em><strong>BUSCARV<\/strong><\/em> es sin duda una de las f\u00f3rmulas intermedias m\u00e1s importantes que tiene Excel. Incluso, se podr\u00eda decir que es la de m\u00e1s aplicaci\u00f3n y utilizaci\u00f3n que otras funciones de Excel.<\/p>\n<hr \/>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en<span style=\"color: #3366ff;\"> <a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n BUSCARV en Excel &#8230; <a title=\"LA FUNCI\u00d3N BUSCARV EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N BUSCARV EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12824,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[569,328,549,556],"tags":[547,592,575],"class_list":["post-12813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-busqueda-y-referencia","category-excel","category-excel-intermedio","category-funciones-especiales","tag-buscarv","tag-buscarx","tag-funciones","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-15T21:36:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-02T23:54:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N BUSCARV EN EXCEL\",\"datePublished\":\"2023-02-15T21:36:51+00:00\",\"dateModified\":\"2023-04-02T23:54:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\"},\"wordCount\":409,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png\",\"keywords\":[\"buscarv\",\"buscarx\",\"funciones\"],\"articleSection\":[\"B\u00fasqueda y Referencia\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\",\"name\":\"LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png\",\"datePublished\":\"2023-02-15T21:36:51+00:00\",\"dateModified\":\"2023-04-02T23:54:50+00:00\",\"description\":\"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N BUSCARV EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LA FUNCI\u00d3N BUSCARV EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM","description":"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.","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:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM","og_description":"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-02-15T21:36:51+00:00","article_modified_time":"2023-04-02T23:54:50+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N BUSCARV EN EXCEL","datePublished":"2023-02-15T21:36:51+00:00","dateModified":"2023-04-02T23:54:50+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/"},"wordCount":409,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png","keywords":["buscarv","buscarx","funciones"],"articleSection":["B\u00fasqueda y Referencia","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/","name":"LA FUNCI\u00d3N BUSCARV EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png","datePublished":"2023-02-15T21:36:51+00:00","dateModified":"2023-04-02T23:54:50+00:00","description":"La funci\u00f3n BUSCARV en Excel nos permite buscar y encontrar datos en una columna espec\u00edfica dentro de una tabla.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/02\/LA-FUNCION-BUSCARV-EN-EXCEL.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N BUSCARV EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LA FUNCI\u00d3N BUSCARV EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=12813"}],"version-history":[{"count":7,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12813\/revisions"}],"predecessor-version":[{"id":13138,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12813\/revisions\/13138"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12824"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}