{"id":13513,"date":"2023-05-17T21:02:18","date_gmt":"2023-05-17T21:02:18","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13513"},"modified":"2023-05-19T12:26:32","modified_gmt":"2023-05-19T12:26:32","slug":"la-funcion-indice-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/","title":{"rendered":"LA FUNCI\u00d3N INDICE EN EXCEL"},"content":{"rendered":"<p>La funci\u00f3n <em><strong>INDICE<\/strong><\/em> es una de las herramientas m\u00e1s \u00fatiles y poderosas en Excel. Es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo. Con esta funci\u00f3n, puedes ahorrar tiempo y esfuerzo al acceder r\u00e1pidamente a la informaci\u00f3n que necesitas. En este art\u00edculo, exploraremos c\u00f3mo funciona la funci\u00f3n <em><strong>I<\/strong><strong>NDICE<\/strong><\/em> y c\u00f3mo puedes aprovecharla al m\u00e1ximo.<\/p>\n<p>En primer lugar, debemos entender que la funci\u00f3n <em><strong>INDICE <\/strong><\/em>se utiliza para extraer un valor o una referencia a una celda espec\u00edfica dentro de una matriz o un rango. Puede ser una matriz unidimensional (una columna o una fila) o una matriz bidimensional (varias columnas y filas).<\/p><div id=\"excel-2632907436\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>La funci\u00f3n <em><strong>INDICE<\/strong><\/em> tambi\u00e9n es muy \u00fatil cuando trabajas con tablas m\u00e1s complejas. Puedes combinarla con otras funciones como <strong><a href=\"https:\/\/excelfull.com\/excel\/la-funcion-coincidir-en-excel\/\" target=\"_blank\" rel=\"noopener\">COINCIDIR<\/a><\/strong> o <strong><a href=\"https:\/\/excelfull.com\/excel\/la-funcion-buscarv-en-excel\/\" target=\"_blank\" rel=\"noopener\">BUSCARV<\/a><\/strong> para realizar b\u00fasquedas m\u00e1s avanzadas.<\/p>\n<p>Adem\u00e1s de extraer valores, la funci\u00f3n <em><strong>INDICE<\/strong><\/em>\u00a0tambi\u00e9n puede utilizarse para devolver rangos de celdas. Esto es \u00fatil cuando necesitas realizar c\u00e1lculos o an\u00e1lisis en un conjunto de datos espec\u00edfico. Puedes establecer los n\u00fameros de fila y columna como rangos en lugar de n\u00fameros individuales.<\/p>\n<h6>LA FUNCI\u00d3N INDICE EN EXCEL: EXPLORANDO SUS FORMAS MATRICIAL Y DE REFERENCIA<\/h6>\n<p>En Excel, la funci\u00f3n <em><strong>INDICE<\/strong><\/em> ofrece diferentes formas de utilizaci\u00f3n, incluyendo su forma matricial y su forma de referencia. Estas variantes ampl\u00edan a\u00fan m\u00e1s su versatilidad y permiten realizar tareas m\u00e1s complejas con datos.<\/p>\n<h6>FORMA MATRICIAL DE LA FUNCI\u00d3N INDICE<\/h6>\n<p>La forma matricial de la funci\u00f3n <em><strong>INDICE<\/strong><\/em>\u00a0es especialmente \u00fatil cuando deseas extraer m\u00faltiples valores de una matriz o un rango en una sola f\u00f3rmula. En lugar de obtener un solo valor, la funci\u00f3n <em><strong>INDICE<\/strong><\/em>\u00a0<strong><em>matricial<\/em><\/strong> puede devolver una matriz de resultados. Esto es posible al ingresar m\u00e1s de un n\u00famero de fila o columna como argumentos.<\/p>\n<p style=\"text-align: center;\"><strong>La sintaxis de la forma <em>matricial<\/em> es la siguiente:<\/strong><\/p>\n<pre style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong>=INDICE(matriz; n\u00fam_fila; [n\u00fam_columna])<\/strong><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13514\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/indice-matriz.png\" alt=\"\" width=\"593\" height=\"301\" \/><\/p>\n<p>La forma de matriz de la funci\u00f3n <em><strong>INDICE<\/strong><\/em> tiene los siguientes argumentos:<\/p>\n<ul>\n<li><strong>Matriz (obligatorio):<\/strong> El rango de celdas que conforma nuestra tabla de datos.<\/li>\n<li><strong>N\u00fam_fila (opcional):<\/strong> El n\u00famero de fila de la celda que contiene el valor que necesitamos.<\/li>\n<li><strong>N\u00fam_columna (opcional):<\/strong> Este argumento es opcional solamente si la Matriz consta de una sola columna, de lo contrario debe especificarse el n\u00famero de columna de la celda buscada.<\/li>\n<\/ul>\n<h6>FORMA DE REFERENCIA DE LA FUNCI\u00d3N INDICE<\/h6>\n<p>La segunda forma de uso de la funci\u00f3n <em><strong>INDICE <\/strong><\/em>en Excel es similar a la anterior, pero con la diferencia de que en lugar de especificar una sola matriz podemos indicar m\u00e1s de una matriz. Esto es \u00fatil cuando solo deseas extraer valores de una parte espec\u00edfica de tus datos.<\/p>\n<p style=\"text-align: center;\"><strong>La sintaxis de la forma <em>de referencia<\/em> es la siguiente:<\/strong><\/p>\n<pre style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong>=INDICE(ref, n\u00fam_fila, [n\u00fam_columna], [n\u00fam_\u00e1rea])<\/strong><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13515\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/indice-ref.png\" alt=\"\" width=\"590\" height=\"324\" \/><\/p>\n<p>La forma de referencia de la funci\u00f3n <em><strong>INDICE<\/strong> <\/em>tiene los siguientes argumentos:<\/p>\n<ul>\n<li><strong>Ref (obligatorio):<\/strong> La referencia a las matrices que tienen los datos.<\/li>\n<li><strong>N\u00fam_fila (obligatorio):<\/strong> El n\u00famero de fila de la celda que deseamos obtener.<\/li>\n<li><strong>N\u00fam_columna (opcional):<\/strong> El n\u00famero de columna de la celda a obtener.<\/li>\n<li><strong>N\u00fam_\u00e1rea (opcional):<\/strong> Ya que Ref puede tener especificados varios rangos como A1:C6, A8:C11 entonces N\u00fam_\u00e1rea indicar\u00e1 cual de los rangos se debe utilizar.<\/li>\n<\/ul>\n<h6>EJEMPLO DE LA FUNCI\u00d3N INDICE EN SU FORMA MATRICIAL Y DE REFERENCIA<\/h6>\n<p><iframe loading=\"lazy\" title=\"3.Aplicando la funci&amp;oacute;n INDICE\" src=\"https:\/\/player.vimeo.com\/video\/349346599?h=a02a053d57&amp;dnt=1&amp;app_id=122963\" width=\"1200\" height=\"675\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h6>CONCLUSI\u00d3N<\/h6>\n<p>En resumen, la funci\u00f3n <em><strong>INDICE<\/strong><\/em> en Excel ofrece una forma matricial y una forma de referencia, ambas \u00fatiles en diferentes situaciones. La forma matricial te permite extraer m\u00faltiples valores en una sola f\u00f3rmula, mientras que la forma de referencia te permite especificar rangos espec\u00edficos dentro de una matriz o un rango m\u00e1s grande. Adem\u00e1s, combinada con otras funciones te brinda una gran flexibilidad y control para buscar y extraer datos en tus hojas de c\u00e1lculo, sin importar su tama\u00f1o o complejidad.<\/p>\n<p>Experimenta con ambas formas y descubre c\u00f3mo puedes optimizar tus tareas de manejo de datos en Excel.<\/p>\n<hr \/>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n INDICE es una &#8230; <a title=\"LA FUNCI\u00d3N INDICE EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N INDICE EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13517,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[569,328,549,556],"tags":[498,575,674],"class_list":["post-13513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-busqueda-y-referencia","category-excel","category-excel-intermedio","category-funciones-especiales","tag-buscar","tag-funciones","tag-indice","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-17T21:02:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-19T12:26:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N INDICE EN EXCEL\",\"datePublished\":\"2023-05-17T21:02:18+00:00\",\"dateModified\":\"2023-05-19T12:26:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\"},\"wordCount\":743,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png\",\"keywords\":[\"buscar\",\"funciones\",\"indice\"],\"articleSection\":[\"B\u00fasqueda y Referencia\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\",\"name\":\"LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png\",\"datePublished\":\"2023-05-17T21:02:18+00:00\",\"dateModified\":\"2023-05-19T12:26:32+00:00\",\"description\":\"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LA FUNCI\u00d3N INDICE EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM","description":"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.","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:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM","og_description":"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-05-17T21:02:18+00:00","article_modified_time":"2023-05-19T12:26:32+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N INDICE EN EXCEL","datePublished":"2023-05-17T21:02:18+00:00","dateModified":"2023-05-19T12:26:32+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/"},"wordCount":743,"commentCount":1,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png","keywords":["buscar","funciones","indice"],"articleSection":["B\u00fasqueda y Referencia","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/","name":"LA FUNCI\u00d3N INDICE EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png","datePublished":"2023-05-17T21:02:18+00:00","dateModified":"2023-05-19T12:26:32+00:00","description":"La funci\u00f3n \u00cdNDICE en Excel es ampliamente utilizada para buscar y recuperar datos de tablas y rangos en una hoja de c\u00e1lculo.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/05\/LA-FUNCION-INDICE-EN-EXCEL.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-indice-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LA FUNCI\u00d3N INDICE EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13513"}],"version-history":[{"count":5,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13513\/revisions"}],"predecessor-version":[{"id":13528,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13513\/revisions\/13528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13517"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}