{"id":3358,"date":"2019-03-25T06:08:59","date_gmt":"2019-03-25T06:08:59","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=3358"},"modified":"2020-11-23T05:53:31","modified_gmt":"2020-11-23T05:53:31","slug":"la-formula-hlookup-buscarh","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/","title":{"rendered":"Funci\u00f3n buscarh en excel (hlookup)."},"content":{"rendered":"<h2>Descripci\u00f3n general de la f\u00f3rmula buscarh en excel<\/h2>\n<p>La funci\u00f3n buscarh (hlookup en excel) sirve para relacionar dos rangos en una hoja de c\u00e1lculo. Se utiliza la funci\u00f3n cuando en el rango base (a donde queremos llevar toda la informaci\u00f3n) tenemos una referencia, y queremos agregar informaci\u00f3n que viene de un rango de referencia, en el cual la informaci\u00f3n est\u00e1 organizada de forma horizontal (y no vertical, como en la f\u00f3rmula buscarv). El que un conjunto de datos est\u00e9 organizado de forma horizontal, significa cada fila contiene un mismo tipo de informaci\u00f3n, y cada observaci\u00f3n est\u00e1 descrita por m\u00e1s de una fila. Por ejemplo<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3360 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup.jpg\" alt=\"F\u00f3rmula HLOOKUP en Google Sheets y Excel\" width=\"1205\" height=\"88\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup.jpg 1205w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup-300x22.jpg 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup-768x56.jpg 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup-1024x75.jpg 1024w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup-360x26.jpg 360w\" sizes=\"auto, (max-width: 1205px) 100vw, 1205px\" \/><\/p>\n<p>En esta imagen, el ID 1 hace referencia a la descripci\u00f3n &#8220;ALI&#8221; y a la descripci\u00f3n ampliada &#8220;ALIMENTOS&#8221;. De esto consiste la organizaci\u00f3n vertical de la informaci\u00f3n.<br \/>\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- adaptable00 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2134179641\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h2>Ejemplo de la funci\u00f3n BUSCARH<\/h2>\n<p>Los par\u00e1metros de la f\u00f3rmula son:<\/p>\n<ul>\n<li>Dato de referencia (el valor que buscas)<\/li>\n<li>El rango de b\u00fasqueda (el rango de referencia)<\/li>\n<li>La posici\u00f3n (fila) donde se encuentra el valor que quieres obtener<\/li>\n<li>Indicador (TRUE\/FALSE) acerca de si la informaci\u00f3n est\u00e1 ordenada. Si es FALSE, la f\u00f3rmula devolver\u00e1 el valor correspondinete a la primera coincidencia exacta. Si no hay una coincidencia, el resultado es un error (#N\/A).<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3365\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3.jpg\" alt=\"\" width=\"1259\" height=\"315\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3.jpg 1259w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3-300x75.jpg 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3-768x192.jpg 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3-1024x256.jpg 1024w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup3-360x90.jpg 360w\" sizes=\"auto, (max-width: 1259px) 100vw, 1259px\" \/><\/p>\n<p>En el ejemplo descrito:<\/p>\n<ul>\n<li>En la fila 10, celda <strong>D10,<\/strong> buscamos la descripci\u00f3n completa correspondiente a <strong>OTR <\/strong>(celda C10)<strong>.<\/strong><\/li>\n<li>El rango de referencia incluye las filas 3 y 4, desde la columna A hasta la I.<\/li>\n<li>El valor de referencia est\u00e1 en la fila 3 (que es la primera fila del rango).<\/li>\n<li>El valor que buscamos est\u00e1 en la fila 4 (que es la segunda fila del rango). Por eso la indicaci\u00f3n en la f\u00f3rmula (2).<\/li>\n<\/ul>\n<p>Descarga el ejemplo en Google Sheets:<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1fkO6FsKeCaRZ-oBL_LiCBo5q0ecTp_3clBqSXSgh6uw\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/1fkO6FsKeCaRZ-oBL_LiCBo5q0ecTp_3clBqSXSgh6uw\/<\/a><\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- adaptable01 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2354381932\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQjL9Ze5_r4seM1W4EQxv37hpuqztVyR5oBuwKR7JwY8RmjYwmH6p1vMOeTWRBzGM1pTYHdC0aQXjYv\/pubhtml?widget=true&amp;headers=false\" width=\"900\" height=\"600\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- adaptable02 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7330666001\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Descripci\u00f3n general de la f\u00f3rmula buscarh en excel La funci\u00f3n buscarh (hlookup en excel) sirve para relacionar dos rangos en una hoja de c\u00e1lculo. Se utiliza la funci\u00f3n cuando en el rango base (a donde queremos llevar toda la informaci\u00f3n) <a href=\"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3370,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,10],"tags":[7,11,198],"class_list":["post-3358","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-google-sheets","tag-excel","tag-google-sheets","tag-hlookup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n buscarh en excel (hlookup). - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Descripci\u00f3n general de la funci\u00f3n buscarh en excel (hlookup), consulta y descarga un ejemplo listo para usar\" \/>\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\/la-formula-hlookup-buscarh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.\" \/>\n<meta property=\"og:description\" content=\"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/\" \/>\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=\"2019-03-25T06:08:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-23T05:53:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"495\" \/>\n\t<meta property=\"og:image:height\" content=\"497\" \/>\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=\"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.\" \/>\n<meta name=\"twitter:description\" content=\"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.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\\\/la-formula-hlookup-buscarh\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Funci\u00f3n buscarh en excel (hlookup).\",\"datePublished\":\"2019-03-25T06:08:59+00:00\",\"dateModified\":\"2020-11-23T05:53:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/\"},\"wordCount\":326,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/hlookup4.jpg\",\"keywords\":[\"Excel\",\"Google Sheets\",\"HLOOKUP\"],\"articleSection\":[\"Excel\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/\",\"name\":\"Funci\u00f3n buscarh en excel (hlookup). - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/hlookup4.jpg\",\"datePublished\":\"2019-03-25T06:08:59+00:00\",\"dateModified\":\"2020-11-23T05:53:31+00:00\",\"description\":\"Descripci\u00f3n general de la funci\u00f3n buscarh en excel (hlookup), consulta y descarga un ejemplo listo para usar\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/hlookup4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/hlookup4.jpg\",\"width\":495,\"height\":497},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/la-formula-hlookup-buscarh\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n buscarh en excel (hlookup).\"}]},{\"@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 buscarh en excel (hlookup). - Business Intelligence MX","description":"Descripci\u00f3n general de la funci\u00f3n buscarh en excel (hlookup), consulta y descarga un ejemplo listo para usar","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\/la-formula-hlookup-buscarh\/","og_locale":"en_US","og_type":"article","og_title":"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.","og_description":"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.","og_url":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2019-03-25T06:08:59+00:00","article_modified_time":"2020-11-23T05:53:31+00:00","og_image":[{"width":495,"height":497,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg","type":"image\/jpeg"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_title":"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.","twitter_description":"Descripci\u00f3n general de la f\u00f3rmula HLOOKUP (en espa\u00f1ol BUSCARH) con un ejemplo.","twitter_image":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.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\/la-formula-hlookup-buscarh\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Funci\u00f3n buscarh en excel (hlookup).","datePublished":"2019-03-25T06:08:59+00:00","dateModified":"2020-11-23T05:53:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/"},"wordCount":326,"commentCount":0,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg","keywords":["Excel","Google Sheets","HLOOKUP"],"articleSection":["Excel","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/","url":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/","name":"Funci\u00f3n buscarh en excel (hlookup). - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg","datePublished":"2019-03-25T06:08:59+00:00","dateModified":"2020-11-23T05:53:31+00:00","description":"Descripci\u00f3n general de la funci\u00f3n buscarh en excel (hlookup), consulta y descarga un ejemplo listo para usar","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2019\/03\/hlookup4.jpg","width":495,"height":497},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/la-formula-hlookup-buscarh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n buscarh en excel (hlookup)."}]},{"@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\/3358","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=3358"}],"version-history":[{"count":15,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/3358\/revisions"}],"predecessor-version":[{"id":4599,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/3358\/revisions\/4599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/3370"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=3358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=3358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=3358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}