{"id":584,"date":"2023-10-22T04:56:33","date_gmt":"2023-10-22T04:56:33","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/"},"modified":"2023-12-25T10:27:53","modified_gmt":"2023-12-25T10:27:53","slug":"vlookup-desde-otra-hoja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/","title":{"rendered":"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2727735317\"><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>Cuando desee buscar un valor de los datos de otra hoja, puede utilizar BUSCARV. Y este tutorial lo explica con un ejemplo f\u00e1cil de seguir. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83718\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-desde-otra-hoja\" width=\"785\" height=\"406\"><\/figure>\n<\/div>\n<p> Puede utilizar los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula:<\/p>\n<ol>\n<li> Primero, ingrese BUSCARV en una celda, y el argumento valor_buscado se refiere a la celda donde tiene el valor de b\u00fasqueda. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-ingrese-vlookup-en-celda\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrez-vlookup-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-vlookup-in-cell\" width=\"523\" height=\"260\"><\/li>\n<li> Despu\u00e9s de eso, ingrese un comando y haga clic en \u00abHoja 2\u00bb para abrirlo. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3-ingrese-una-coma-y-haga clic-en-otra-hoja\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-une-virgule-et-cliquez-sur-une-autre-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-comma-and-click-another-sheet\" width=\"513\" height=\"197\"><\/li>\n<li> Ahora en \u201cHoja 2\u201d selecciona la tabla donde tienes el ID del producto y la cantidad. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-selecciona-la-tabla-donde-tienes-datos-para-buscar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-la-table-dans-laquelle-vous-avez-des-donnees-a-rechercher.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-table-where-you-have-data-to-lookup\" width=\"475\" height=\"389\"><\/li>\n<li> Luego ingrese una coma nuevamente y especifique 2 en el argumento col_index_num. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-ingrese-una-coma-y-especifique-un-argumento-num\u00e9rico\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-entrez-une-virgule-et-specifiez-un-argument-numerique.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-comma-and-specify-number-argument\" width=\"463\" height=\"109\"><\/li>\n<li> Desde all\u00ed, en [range_lookup], ingrese 0 o FALSO para una b\u00fasqueda de coincidencia exacta. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"6-ingrese-cero-o-falso-para-coincidencia-exacta\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-zero-ou-faux-pour-une-correspondance-exacte.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-zero-or-false-for-exact-match\" width=\"464\" height=\"107\"><\/li>\n<li> Al final, cierre la funci\u00f3n y presione Entrar para obtener el resultado en la celda de la hoja \u201c1\u201d. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"7-funci\u00f3n-finalmente-cerrada\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-a-la-fin-fermer-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"in-the-end-close-the-function\" width=\"451\" height=\"227\"><\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Notas importantes<\/h2>\n<p> Si cambias el nombre de la hoja donde tienes los datos, Excel tambi\u00e9n es lo suficientemente inteligente como para cambiarlo en tu f\u00f3rmula. Para que no tengas que preocuparte antes de cambiar el nombre de las hojas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83726\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-changement-de-nom-de-feuille-est-mis-a-jour-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"el cambio de nombre de la hoja se actualiza en la f\u00f3rmula\" width=\"519\" height=\"262\"><\/figure>\n<\/div>\n<p> Pero debe asegurarse de que una vez que se elimine la hoja de datos, su f\u00f3rmula muestre el #REF. Error en el resultado. Y no hay forma de recuperar una hoja. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83727\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-supprimer-la-feuille-donne-une-erreur-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"eliminar-hoja-da-ref-error\" width=\"516\" height=\"298\"><\/figure>\n<\/div>\n<p> Tambi\u00e9n puede convertir datos de otra hoja en un rango con nombre y hacer referencia a \u00e9l en BUSCARV. Con esto, no es necesario abrir la segunda hoja al escribir la f\u00f3rmula. En su lugar, puede ingresar el rango nombrado y Excel har\u00e1 referencia a los datos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83729\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-donnees-de-la-plage-de-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"datos-del-rango-de-nombres\" width=\"511\" height=\"295\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/es\/a\/\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-error-busqueda-virtual\/\">IFERROR con BUSCARV en Excel para reemplazar #N\/A en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/busqueda-bidireccional\/\">Realizar una b\u00fasqueda bidireccional en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/busqueda-inversa\/\">BUSCARV inversa (hacia atr\u00e1s: de derecha a izquierda) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/coincidencia-de-vsearch\/\">Combinando BUSCARV COINCIDIR en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/vlookup-varios-criterios\/\">BUSCARV con m\u00faltiples criterios en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cuando desee buscar un valor de los datos de otra hoja, puede utilizar BUSCARV. Y este tutorial lo explica con un ejemplo f\u00e1cil de seguir. Puede utilizar los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula: Primero, ingrese BUSCARV en una celda, y el argumento valor_buscado se refiere a la celda donde tiene el valor de [&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-584","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 buscarv desde otra hoja?<\/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\/vlookup-desde-otra-hoja\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?\" \/>\n<meta property=\"og:description\" content=\"Cuando desee buscar un valor de los datos de otra hoja, puede utilizar BUSCARV. Y este tutorial lo explica con un ejemplo f\u00e1cil de seguir. Puede utilizar los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula: Primero, ingrese BUSCARV en una celda, y el argumento valor_buscado se refiere a la celda donde tiene el valor de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/\",\"name\":\"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\",\"datePublished\":\"2023-10-22T04:56:33+00:00\",\"dateModified\":\"2023-12-25T10:27:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?\"}]},{\"@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 buscarv desde otra hoja?","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\/vlookup-desde-otra-hoja\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?","og_description":"Cuando desee buscar un valor de los datos de otra hoja, puede utilizar BUSCARV. Y este tutorial lo explica con un ejemplo f\u00e1cil de seguir. Puede utilizar los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula: Primero, ingrese BUSCARV en una celda, y el argumento valor_buscado se refiere a la celda donde tiene el valor de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:53+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/","url":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/","name":"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png","datePublished":"2023-10-22T04:56:33+00:00","dateModified":"2023-12-25T10:27:53+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-depuis-une-autre-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/vlookup-desde-otra-hoja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar buscarv desde otra hoja?"}]},{"@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\/584","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=584"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/584\/revisions"}],"predecessor-version":[{"id":1242,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/584\/revisions\/1242"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}