{"id":3804,"date":"2020-08-08T07:03:48","date_gmt":"2020-08-08T07:03:48","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=3804"},"modified":"2020-12-01T07:47:53","modified_gmt":"2020-12-01T07:47:53","slug":"xlookup-excel-funciones","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/","title":{"rendered":"Funci\u00f3n XLOOKUP Excel"},"content":{"rendered":"<h2>Funci\u00f3n buscarv en Excel y google sheets.<\/h2>\n<p>Empecemos por la f\u00f3rmula m\u00e1s conocida: funci\u00f3n <strong>BUSCARV en excel<\/strong> (en algunas versiones tambi\u00e9n se llama <strong>CONSULTAV<\/strong>, en ingl\u00e9s <strong>VLOOKUP<\/strong>). Este es el caso t\u00edpico (descarga el ejemplo al final de la explicaci\u00f3n):<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>\n(adsbygoogle = window.adsbygoogle || []).push({});\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><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\" \/><\/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: 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><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\" \/><\/p>\n<p style=\"text-align: left;\">Y debe resultar lo siguiente:<\/p>\n<p><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\" \/><\/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>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h2>Funci\u00f3n XLOOKUP en excel<\/h2>\n<p>Esta f\u00f3rmula es mucho m\u00e1s sencilla, .<\/p>\n<blockquote><p>La tabla es distinta:<\/p>\n<p><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\" \/><\/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>XLOOKUP<\/strong><\/span><strong>(&#8220;<\/strong><span style=\"color: #0000ff;\"><strong>VALOR BUSCADO<\/strong><\/span><strong>&#8220;,&#8221;<\/strong><span style=\"color: #0000ff;\"><strong>COLUMNA DE B\u00daSQUEDA (NOMBRES)<\/strong><\/span><strong>&#8220;,&#8221;<span style=\"color: #0000ff;\">COLUMNA DEL RESULTADO (EDADES)<\/span>&#8220;<\/strong><strong>)<\/strong><\/p>\n<p style=\"text-align: left;\">La f\u00f3rmula debe lucir as\u00ed:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3805\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/XLOOKUP.jpg\" alt=\"\" width=\"400\" height=\"285\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/XLOOKUP.jpg 771w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/XLOOKUP-300x214.jpg 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/XLOOKUP-768x548.jpg 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/XLOOKUP-360x257.jpg 360w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p style=\"text-align: left;\">Esta f\u00f3rmula es incre\u00edblemente simple. No importa en qu\u00e9 posici\u00f3n se encuentran las columnas! El \u00fanico inconveniente es que solo est\u00e1 disponible en las versiones m\u00e1s recientes de Excel. Tambi\u00e9n es un buen reto: te puedes proponer escribir una funci\u00f3n personalizada que replique los resultados de esta f\u00f3rmula. Puedes hacerlo con VBA o con alguna otra integraci\u00f3n. Si logras hacerlo, puedes compartir tu resultado con nosotros. Pon tus datos en los comentarios de esta publicaci\u00f3n.<\/p>\n<\/blockquote>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>Descarga el ejemplo:<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/www.fditf.com\/bi\/download\/3807\/?tmstv=1782366621\" rel=\"nofollow\" id=\"download-link-3807\" data-redirect=\"false\" >\n\tXLOOKUP<\/a>\n<\/strong><\/span><\/p>\n<p>&nbsp;<\/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>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Funci\u00f3n buscarv en Excel y google sheets. Empecemos por la f\u00f3rmula m\u00e1s conocida: funci\u00f3n BUSCARV en excel (en algunas versiones tambi\u00e9n se llama CONSULTAV, en ingl\u00e9s VLOOKUP). Este es el caso t\u00edpico (descarga el ejemplo al final de la explicaci\u00f3n): <a href=\"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[7,27,28],"class_list":["post-3804","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-excel-functions","tag-funciones-en-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n XLOOKUP Excel - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Un ejemplo de la funci\u00f3n XLOKKUP en Excel\" \/>\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\/xlookup-excel-funciones\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ejemplo de XLOOKUP en Excel\" \/>\n<meta property=\"og:description\" content=\"Ejemplo de XLOOKUP en Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/xlookup-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=\"2020-08-08T07:03:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-01T07:47:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"590\" \/>\n\t<meta property=\"og:image:height\" content=\"295\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Ejemplo de XLOOKUP en Excel\" \/>\n<meta name=\"twitter:description\" content=\"Ejemplo de XLOOKUP en Excel\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg\" \/>\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=\"2 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\\\/xlookup-excel-funciones\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Funci\u00f3n XLOOKUP Excel\",\"datePublished\":\"2020-08-08T07:03:48+00:00\",\"dateModified\":\"2020-12-01T07:47:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/\"},\"wordCount\":318,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/excel.jpg\",\"keywords\":[\"Excel\",\"funciones en excel\",\"Funciones en Excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/\",\"name\":\"Funci\u00f3n XLOOKUP Excel - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/excel.jpg\",\"datePublished\":\"2020-08-08T07:03:48+00:00\",\"dateModified\":\"2020-12-01T07:47:53+00:00\",\"description\":\"Un ejemplo de la funci\u00f3n XLOKKUP en Excel\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/excel.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/excel.jpg\",\"width\":590,\"height\":295},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/xlookup-excel-funciones\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n XLOOKUP Excel\"}]},{\"@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":"Funci\u00f3n XLOOKUP Excel - Business Intelligence MX","description":"Un ejemplo de la funci\u00f3n XLOKKUP en Excel","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\/xlookup-excel-funciones\/","og_locale":"en_US","og_type":"article","og_title":"Ejemplo de XLOOKUP en Excel","og_description":"Ejemplo de XLOOKUP en Excel","og_url":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2020-08-08T07:03:48+00:00","article_modified_time":"2020-12-01T07:47:53+00:00","og_image":[{"width":590,"height":295,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","type":"image\/jpeg"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_title":"Ejemplo de XLOOKUP en Excel","twitter_description":"Ejemplo de XLOOKUP en Excel","twitter_image":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Funci\u00f3n XLOOKUP Excel","datePublished":"2020-08-08T07:03:48+00:00","dateModified":"2020-12-01T07:47:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/"},"wordCount":318,"commentCount":0,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","keywords":["Excel","funciones en excel","Funciones en Excel"],"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/","url":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/","name":"Funci\u00f3n XLOOKUP Excel - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","datePublished":"2020-08-08T07:03:48+00:00","dateModified":"2020-12-01T07:47:53+00:00","description":"Un ejemplo de la funci\u00f3n XLOKKUP en Excel","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2020\/08\/excel.jpg","width":590,"height":295},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/xlookup-excel-funciones\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n XLOOKUP Excel"}]},{"@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\/3804","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=3804"}],"version-history":[{"count":6,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/3804\/revisions"}],"predecessor-version":[{"id":3812,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/3804\/revisions\/3812"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/3811"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=3804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=3804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=3804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}