{"id":1535,"date":"2018-11-10T21:54:48","date_gmt":"2018-11-10T21:54:48","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=1535"},"modified":"2021-01-06T22:18:45","modified_gmt":"2021-01-06T22:18:45","slug":"vlookup-entre-archivos-en-googlesheets","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/","title":{"rendered":"La funci\u00f3n BUSCARV google sheets"},"content":{"rendered":"<h2>La funci\u00f3n BUSCARV (vlookup) en google sheets<\/h2>\n<p>La f\u00f3rmula vlookup en espa\u00f1ol es buscarv. Se trata de las f\u00f3rmulas m\u00e1s populares: <strong>BUSCARV<\/strong> (en algunas versiones tambi\u00e9n se llama <strong>CONSULTAV<\/strong>, en ingl\u00e9s <strong>VLOOKUP<\/strong>). Este es el caso t\u00edpico (<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/www.fditf.com\/bi\/download\/120\/?tmstv=1781867762\" rel=\"nofollow\" id=\"download-link-120\" data-redirect=\"false\" >\n\t#Buscarv a la izquierda<\/a>\n):<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<p>&nbsp;<\/p>\n<p>&nbsp;<\/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: center;\"><strong>=<\/strong><span style=\"color: #0000ff;\"><strong>BUSCARV<\/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>La funci\u00f3n VLOOKUP (buscarv) en excel<\/h2>\n<p>La receta es simple: mientras tecleas la f\u00f3rmula en el archivo donde trabaja, elige los datos del otro archivo. Excel agregar\u00e1:<br \/>\ni) en un primer momento, una referencia simple al archivo. indicando nombre de archivo y hoja donde se encuentran los datos, de esta forma: [<span style=\"color: #008000;\">NombreDelArchivo<\/span>]<span style=\"color: #ff0000;\">Hoja!<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1823\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase1.png\" alt=\"\" width=\"1470\" height=\"704\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase1.png 1470w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase1-300x144.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase1-768x368.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase1-1024x490.png 1024w\" sizes=\"auto, (max-width: 1470px) 100vw, 1470px\" \/><br \/>\nii) cuando cierres el archivo de referencia, Excel agregar\u00e1 la ruta completa:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1824\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase2.png\" alt=\"\" width=\"1188\" height=\"426\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase2.png 1188w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase2-300x108.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase2-768x275.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/fase2-1024x367.png 1024w\" sizes=\"auto, (max-width: 1188px) 100vw, 1188px\" \/><\/p>\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>Vlookup entre archivos en google sheets<\/h2>\n<p>La funci\u00f3n buscarv en google sheets para hacer consultas entre hojas funciona casi igual que en Excel (solo debemos auxiliarnos de la funci\u00f3n importrange de google sheets), ocurre que ahora estamos en un ambiente web, y necesitamos hacer un paso adicional. En general, lo que haremos es llevar datos del libro 2 al libro 1 (donde queremos hacer la consulta de los datos), y despu\u00e9s haremos la consulta. Este es el proceso a seguir:<\/p>\n<p>0. Obtener\/conceder permisos para consultar datos de forma remota.<br \/>\n1. Hacer la consulta.<\/p>\n<h3>Obtener\/conceder permisos para consultar datos de forma remota.<\/h3>\n<p>Esta es la situaci\u00f3n: si t\u00fa tienes permiso para ver\/editar ambos archivos, no tendr\u00e1s problemas. Si no tienes permisos para alguno de los archivos (aqu\u00e9l donde consultas la informaci\u00f3n, y el archivo a donde quieres llevar los datos), no funcionar\u00e1. Sigue estos pasos:<\/p>\n<p>i) Crea una hoja nueva en el archivo a donde llevar\u00e1s los datos: no importa el nombre, solo aseg\u00farate de que est\u00e9 vac\u00eda.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1825\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos.png\" alt=\"\" width=\"376\" height=\"362\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos.png 376w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos-300x289.png 300w\" sizes=\"auto, (max-width: 376px) 100vw, 376px\" \/><\/p>\n<p>ii) Inserta esta f\u00f3rmula:<\/p>\n<p><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span style=\"color: #993366;\"><span class=\" default-formula-text-color\" dir=\"auto\">IMPORTRANGE<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><\/span><span class=\" string \" dir=\"auto\">&#8220;<span style=\"color: #ff0000;\">https:\/\/docs.google.com\/spreadsheets\/d\/1Essf6EjD-e4E_nlnMfzbqCLZBrUCOHt8AJuIpBDezrc<\/span>&#8220;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;<span style=\"color: #0000ff;\">Sheet1!<\/span><span style=\"color: #339966;\">A1:B6<\/span>&#8220;<\/span><span class=\" default-formula-text-color\" dir=\"auto\" style=\"color: #993366;\">)<\/span><\/p>\n<p>La f\u00f3rmula tiene dos argumentos: el URL de la hoja en Google Sheets que quieres consultar, y el rango que quieres extraer (especificando hoja y rango). El URL est\u00e1 en la barra de direcci\u00f3n, \u00fasalo hasta donde llega el ID de la hoja (\u00faltima secci\u00f3n de la direcci\u00f3n, ub\u00edcala con las diagonales):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1826\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos2.png\" alt=\"\" width=\"835\" height=\"431\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos2.png 835w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos2-300x155.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos2-768x396.png 768w\" sizes=\"auto, (max-width: 835px) 100vw, 835px\" \/><\/p>\n<p>iii) Concede los permisos:<\/p>\n<p>Despu\u00e9s de insertar la f\u00f3rmula, ver\u00e1s algo as\u00ed:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1828\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos3.png\" alt=\"\" width=\"1080\" height=\"425\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos3.png 1080w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos3-300x118.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos3-768x302.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos3-1024x403.png 1024w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/p>\n<p>Acerca el mouse a la celda A1, y ver\u00e1s un bot\u00f3n pidiendo que concedas permisos. Da click en &#8220;Allow access&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1830\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos4.png\" alt=\"\" width=\"636\" height=\"419\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos4.png 636w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos4-300x198.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos4-120x80.png 120w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/p>\n<p>Listo. Los permisos est\u00e1n concedidos, ya puedes acceder a los datos de ese libro (<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Essf6EjD-e4E_nlnMfzbqCLZBrUCOHt8AJuIpBDezrc\/edit#gid=0\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup libro 2<\/a>). Cualquier cambio que hagas, ser\u00e1 reflejado de forma instant\u00e1nea. Por ejemplo: si borras todos los datos del libro 2, el libro 1 no mostrar\u00e1 nada.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1831\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos5.png\" alt=\"\" width=\"1108\" height=\"494\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos5.png 1108w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos5-300x134.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos5-768x342.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos5-1024x457.png 1024w\" sizes=\"auto, (max-width: 1108px) 100vw, 1108px\" \/><\/p>\n<h3><\/h3>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- VlookupEnGoogleSheets --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2606860231\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h3>Hacer la consulta.<\/h3>\n<p>En principio, ya puedes hacer tu consulta con los datos existentes en la hoja que acabas de crear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1832\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos6.png\" alt=\"\" width=\"519\" height=\"406\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos6.png 519w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos6-300x235.png 300w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><\/p>\n<p>Puedes consultar aqu\u00ed este ejemplo:\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Kk8puVZZvxP2eJ-9wdl7tfG4UALCh2nYFjD2g091GlQ\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup simple<\/a><\/p>\n<p>Sin embargo, ya tienes una hoja extra en el archivo. Y no es necesario que la tengas. Como ya hiciste el proceso para la obtenci\u00f3n de permisos, ya puedes borrar la hoja y anidar la f\u00f3rmula en la consulta vertical. De modo que los datos son virtuales (existen solo en una instancia que no puedes ver). La f\u00f3rmula queda as\u00ed:<\/p>\n<p><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">VLOOKUP<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">B1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span style=\"color: #ff0000;\"><span class=\" default-formula-text-color\" dir=\"auto\">IMPORTRANGE<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" string \" dir=\"auto\">&#8220;https:\/\/docs.google.com\/spreadsheets\/d\/1Essf6EjD-e4E_nlnMfzbqCLZBrUCOHt8AJuIpBDezrc&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">&#8220;Sheet1!A1:B6&#8221;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">0<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/p>\n<p>La parte de la f\u00f3rmula en rojo est\u00e1 indicando que el rango a consultar viene de otro libro. El resultado es el mismo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1834\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos7.png\" alt=\"\" width=\"1228\" height=\"492\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos7.png 1228w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos7-300x120.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos7-768x308.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos7-1024x410.png 1024w\" sizes=\"auto, (max-width: 1228px) 100vw, 1228px\" \/><\/p>\n<p>Aqu\u00ed puedes consultar el ejemplo con la f\u00f3rmula anidada:\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1sBQQEZOtO3Qs56ApUzvJ_XRRpiKu2UId-KWiRP9oJVA\/edit#gid=0\" target=\"_blank\" rel=\"noopener noreferrer\">F\u00f3rmula anidada<\/a><\/p>\n<p>Parece un poco engorroso en Google Sheets, sin embargo con la pr\u00e1ctica se hace muy \u00e1gil, y en segundos lo podr\u00e1s ejecutar. Considera que el si usas la f\u00f3rmula anidada, es indispensable pasar por el proceso para conceder permisos, y tambi\u00e9n considera que este proceso solo ocurre una sola vez.<\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- post_edate --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4902726138\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p>Conoce el potencial de toda la suite de Google, obt\u00e9n una prueba gratuita de la suite; m\u00e1s informaci\u00f3n en este enlace (Google): <a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/goo.gl\/ZPXKU2<\/a><\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-267 size-medium\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/google-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n BUSCARV (vlookup) en google sheets La f\u00f3rmula vlookup en espa\u00f1ol es buscarv. Se trata de las f\u00f3rmulas m\u00e1s populares: BUSCARV (en algunas versiones tambi\u00e9n se llama CONSULTAV, en ingl\u00e9s VLOOKUP). Este es el caso t\u00edpico (): Tienes una <a href=\"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1838,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,10],"tags":[158,157,7,11,159],"class_list":["post-1535","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-google-sheets","tag-buscarv","tag-importrange","tag-excel","tag-google-sheets","tag-vlookup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>La funci\u00f3n BUSCARV google sheets - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets\" \/>\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\/vlookup-entre-archivos-en-googlesheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"La funci\u00f3n BUSCARV google sheets - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/\" \/>\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-11-10T21:54:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-06T22:18:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"688\" \/>\n\t<meta property=\"og:image:height\" content=\"492\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"La funci\u00f3n BUSCARV google sheets\",\"datePublished\":\"2018-11-10T21:54:48+00:00\",\"dateModified\":\"2021-01-06T22:18:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/\"},\"wordCount\":801,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/permisos8.png\",\"keywords\":[\"=BUSCARV()\",\"=IMPORTRANGE()\",\"Excel\",\"Google Sheets\",\"VLOOKUP\"],\"articleSection\":[\"Excel\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/\",\"name\":\"La funci\u00f3n BUSCARV google sheets - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/permisos8.png\",\"datePublished\":\"2018-11-10T21:54:48+00:00\",\"dateModified\":\"2021-01-06T22:18:45+00:00\",\"description\":\"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/permisos8.png\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/permisos8.png\",\"width\":688,\"height\":492},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/vlookup-entre-archivos-en-googlesheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"La funci\u00f3n BUSCARV google sheets\"}]},{\"@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":"La funci\u00f3n BUSCARV google sheets - Business Intelligence MX","description":"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets","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\/vlookup-entre-archivos-en-googlesheets\/","og_locale":"en_US","og_type":"article","og_title":"La funci\u00f3n BUSCARV google sheets - Business Intelligence MX","og_description":"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets","og_url":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-11-10T21:54:48+00:00","article_modified_time":"2021-01-06T22:18:45+00:00","og_image":[{"width":688,"height":492,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"La funci\u00f3n BUSCARV google sheets","datePublished":"2018-11-10T21:54:48+00:00","dateModified":"2021-01-06T22:18:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/"},"wordCount":801,"commentCount":0,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.png","keywords":["=BUSCARV()","=IMPORTRANGE()","Excel","Google Sheets","VLOOKUP"],"articleSection":["Excel","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/","url":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/","name":"La funci\u00f3n BUSCARV google sheets - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.png","datePublished":"2018-11-10T21:54:48+00:00","dateModified":"2021-01-06T22:18:45+00:00","description":"funci\u00f3n buscarv en google sheets, vlookup importrange. Incluye un ejemplo completo de buscarv en excel y google sheets","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/permisos8.png","width":688,"height":492},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/vlookup-entre-archivos-en-googlesheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"La funci\u00f3n BUSCARV google sheets"}]},{"@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\/1535","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=1535"}],"version-history":[{"count":22,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/1535\/revisions"}],"predecessor-version":[{"id":5412,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/1535\/revisions\/5412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/1838"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=1535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=1535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=1535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}