{"id":123,"date":"2018-01-12T03:39:44","date_gmt":"2018-01-12T03:39:44","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=123"},"modified":"2023-07-08T20:54:06","modified_gmt":"2023-07-08T20:54:06","slug":"buscarv-a-la-izquierda-excel-funciones","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/","title":{"rendered":"BUSCARV  excel a la izquierda!"},"content":{"rendered":"<h2>BuscarV regular en excel.<\/h2>\n<p>Comencemos con la f\u00f3rmula m\u00e1s reconocida: BUSCARV (en algunas versiones tambi\u00e9n conocida como CONSULTAV en Excel o VLOOKUP en ingl\u00e9s). Este es un escenario habitual que se ilustra al final de la explicaci\u00f3n con un ejemplo descargable. BUSCARV es una funci\u00f3n muy utilizada en Excel que permite buscar un valor espec\u00edfico en una tabla y devolver un resultado relacionado desde otra columna. Esta f\u00f3rmula es especialmente \u00fatil cuando se trabaja con conjuntos de datos extensos y se necesita extraer informaci\u00f3n espec\u00edfica de manera r\u00e1pida y precisa. Al dominar la funci\u00f3n BUSCARV, podr\u00e1s realizar b\u00fasquedas efectivas y agilizar tus tareas de an\u00e1lisis y gesti\u00f3n de datos en Excel. Recuerda que la pr\u00e1ctica y la familiaridad con las diferentes funciones de Excel te ayudar\u00e1n a mejorar tus habilidades y optimizar tus resultados en el manejo de hojas de c\u00e1lculo. \u00a1Sigue explorando y aprendiendo m\u00e1s sobre las posibilidades que Excel ofrece! Ve el ejemplo<br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- RegularPostHeader --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: inline-block; width: 728px; height: 90px;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4391345816\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<blockquote>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Tienes una tabla de datos, y requieres hacer una consulta con una f\u00f3rmula, de modo que no tengas que regresar a ver la tabla cada vez que necesitas un dato.<\/li>\n<li><strong>Ejemplo.\u00a0<\/strong>Tenemos la tabla:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/tabla-300x244.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-128 aligncenter\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/tabla-300x244-300x244.png\" alt=\"\" width=\"300\" height=\"244\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Quieres que\u00a0Excel te informe la edad cuando tu le informas el nombre. Si tienes el dato &#8220;Pedro&#8221;, quieres que la f\u00f3rmula te diga &#8220;23&#8221;.<\/li>\n<li>La\u00a0estructura de la f\u00f3rmula es:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>=<\/strong><span style=\"color: #0000ff;\"><strong>CONSULTAV<\/strong><\/span><strong>(&#8220;<\/strong><span style=\"color: #0000ff;\"><strong>VALOR<\/strong><\/span><strong>&#8220;,&#8221;<\/strong><span style=\"color: #0000ff;\"><strong>TABLA DE DATOS<\/strong><\/span><strong>&#8220;,&#8221;<\/strong><span style=\"color: #0000ff;\"><strong>\u00bfEN QU\u00c9 COLUMNA EST\u00c1 EL DATO QUE BUSCAS?<\/strong><\/span><strong>&#8220;,<\/strong><span style=\"color: #0000ff;\"><strong>0<\/strong><\/span><strong>)<\/strong><\/p>\n<p style=\"text-align: left;\">El cero al final impedir\u00e1 que Excel te devuleva un resultado &#8220;parecido&#8221; (tema de otro post). La f\u00f3rmula debe lucir as\u00ed:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/consultav-287x300.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-127 aligncenter\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/consultav-287x300-287x300.png\" alt=\"\" width=\"287\" height=\"300\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/consultav-287x300.png 287w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/consultav-287x300-239x250.png 239w\" sizes=\"auto, (max-width: 287px) 100vw, 287px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Y debe resultar lo siguiente:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/form-300x262.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-126 aligncenter\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/form-300x262-300x262.png\" alt=\"\" width=\"300\" height=\"262\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/form-300x262.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/form-300x262-286x250.png 286w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>BuscarV a la izquierda.<\/h2>\n<p>Es pr\u00e1cticamente lo mismo, pero cambiando el orden de las columnas. En la f\u00f3rmula de arriba, el dato que buscamos est\u00e1 a la derecha, en este ejemplo, el dato que buscamos est\u00e1 a la izquierda.<\/p>\n<blockquote><p>La tabla es distinta:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/tabla02-300x227.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-125\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/tabla02-300x227-300x227.png\" alt=\"\" width=\"300\" height=\"227\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Quieres que\u00a0Excel te informe la edad cuando tu le informas el nombre. Si tienes el dato &#8220;Pedro&#8221;, quieres que la f\u00f3rmula te diga &#8220;23&#8221;.<\/li>\n<li>La\u00a0estructura de la f\u00f3rmula es:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>=<\/strong><span style=\"color: #0000ff;\"><strong>INDICE<\/strong><\/span><strong>(&#8220;<\/strong><span style=\"color: #0000ff;\"><strong>MATRIZ DE B\u00daSQUEDA (COLUMNA DE LA EDAD)<\/strong><\/span><strong>&#8220;,&#8221;<\/strong><span style=\"color: #0000ff;\"><strong>VALOR BUSCADO (\u00cdNDICE)<\/strong><\/span><strong>&#8220;<\/strong><strong>)<\/strong><\/p>\n<p style=\"text-align: left;\">Solo que haremos un reemplazo. En la parte de valor buscado usamos otra f\u00f3rmula:<\/p>\n<p style=\"text-align: center;\"><strong>=<\/strong><span style=\"color: #ff0000;\"><strong>COINCIDIR<\/strong><\/span><strong>(<\/strong><strong>&#8220;<\/strong><span style=\"color: #0000ff;\"><strong>VALOR BUSCADO (NOMBRE)<\/strong><\/span><strong>&#8220;,&#8221;<span style=\"color: #0000ff;\">MATRIZ DE B\u00daSQUEDA COLUMNA DEL NOMBRE<\/span>&#8220;, 0<\/strong><strong>)<\/strong><\/p>\n<p style=\"text-align: left;\">El cero evitar\u00e1 errores (tema de otro post). La f\u00f3rmula debe lucir as\u00ed:<\/p>\n<p><a href=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-300x172.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-124 aligncenter\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-300x172-300x172.png\" alt=\"\" width=\"300\" height=\"172\" \/><\/a><\/p>\n<p style=\"text-align: left;\">En ingl\u00e9s cambia <strong>INDICE<\/strong> por <strong>INDEX<\/strong>, y <strong>COINCIDIR<\/strong> por <strong>MATCH<\/strong>.<\/p>\n<\/blockquote>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>Utiliza la funci\u00f3n. Descarga el ejemplo:<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/www.fditf.com\/bi\/download\/120\/?tmstv=1781145404\" rel=\"nofollow\" id=\"download-link-120\" data-redirect=\"false\" >\n\t#Buscarv a la izquierda<\/a>\n<\/strong><\/span><\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- RegularPostBottom --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2196072090\" data-ad-format=\"auto\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>BuscarV regular en excel. Comencemos con la f\u00f3rmula m\u00e1s reconocida: BUSCARV (en algunas versiones tambi\u00e9n conocida como CONSULTAV en Excel o VLOOKUP en ingl\u00e9s). Este es un escenario habitual que se ilustra al final de la explicaci\u00f3n con un ejemplo <a href=\"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":129,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[7,27],"class_list":["post-123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-excel-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BUSCARV excel a la izquierda! - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.\" \/>\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.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BUSCARV excel a la izquierda! - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-12T03:39:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-08T20:54:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"585\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"BUSCARV excel a la izquierda!\",\"datePublished\":\"2018-01-12T03:39:44+00:00\",\"dateModified\":\"2023-07-08T20:54:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/\"},\"wordCount\":436,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/left-1-1024x585.png\",\"keywords\":[\"Excel\",\"funciones en excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/\",\"name\":\"BUSCARV excel a la izquierda! - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/left-1-1024x585.png\",\"datePublished\":\"2018-01-12T03:39:44+00:00\",\"dateModified\":\"2023-07-08T20:54:06+00:00\",\"description\":\"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/left-1-1024x585.png\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/left-1-1024x585.png\",\"width\":1024,\"height\":585},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/buscarv-a-la-izquierda-excel-funciones\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BUSCARV excel a la izquierda!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BUSCARV excel a la izquierda! - Business Intelligence MX","description":"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.","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.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/","og_locale":"en_US","og_type":"article","og_title":"BUSCARV excel a la izquierda! - Business Intelligence MX","og_description":"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.","og_url":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-01-12T03:39:44+00:00","article_modified_time":"2023-07-08T20:54:06+00:00","og_image":[{"width":1024,"height":585,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"BUSCARV excel a la izquierda!","datePublished":"2018-01-12T03:39:44+00:00","dateModified":"2023-07-08T20:54:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/"},"wordCount":436,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png","keywords":["Excel","funciones en excel"],"articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/","url":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/","name":"BUSCARV excel a la izquierda! - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png","datePublished":"2018-01-12T03:39:44+00:00","dateModified":"2023-07-08T20:54:06+00:00","description":"BUSCARV a la izquierda en Excel usando la combinaci\u00f3n indice y coincidir o INDEX MATCH, ve un ejemplo aqu\u00ed y descarga los archivos.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/left-1-1024x585.png","width":1024,"height":585},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/buscarv-a-la-izquierda-excel-funciones\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"BUSCARV excel a la izquierda!"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":12,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":19654,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/123\/revisions\/19654"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/129"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}