{"id":27562,"date":"2026-04-06T12:30:00","date_gmt":"2026-04-06T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=27562"},"modified":"2026-04-05T09:52:56","modified_gmt":"2026-04-05T14:52:56","slug":"buscador-dinamico-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/","title":{"rendered":"Buscador din\u00e1mico en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-buscador-dinamico-en-excel-guia-paso-a-paso\">Buscador din\u00e1mico en Excel: Gu\u00eda paso a paso<\/h1>\n\n\n\n<p>\u00bfTe has enfrentado alguna vez a una tabla con miles de registros y te resulta imposible encontrar lo que necesitas r\u00e1pidamente? Navegar por hojas de c\u00e1lculo interminables puede ser agotador y propenso a errores. Afortunadamente, no necesitas ser un experto en programaci\u00f3n ni depender de macros complejas para solucionar este problema.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Buscador Inteligente en Excel sin Macros: Filtro Din\u00e1mico Paso a Paso\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/NiwFW4Ekavw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">En este art\u00edculo, te ense\u00f1ar\u00e9 c\u00f3mo construir un <strong>buscador din\u00e1mico en Excel<\/strong>. Con esta herramienta, podr\u00e1s filtrar informaci\u00f3n en tiempo real, buscar palabras clave dentro de varias columnas simult\u00e1neamente e incluso aplicar m\u00faltiples criterios de b\u00fasqueda independientes. Al finalizar este tutorial, tendr\u00e1s un panel inteligente y automatizado que te ahorrar\u00e1 horas de trabajo. \u00a1Comencemos!<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-629087f1\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-paso-1-convertir-tus-datos-en-una-tabla-oficial\">Paso 1: Convertir tus datos en una tabla oficial<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-7804fe2f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h42m07s165-1024x398.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h42m07s165-scaled.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h42m07s165-scaled.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h42m07s165-1024x398.avif\" alt=\"Crear tabla en Excel para buscador\" class=\"uag-image-27686\" width=\"1024\" height=\"398\" title=\"Nombrar tabla de ventas en Excel.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">Para que nuestro panel funcione correctamente y se actualice si agregamos m\u00e1s informaci\u00f3n en el futuro, el primer paso es vital: debemos decirle a Excel que nuestros datos son una tabla.<\/p>\n\n\n\n<p>Simplemente haz clic en cualquier celda que contenga tu informaci\u00f3n y presiona la combinaci\u00f3n de teclas <code>Ctrl + T<\/code>. Aseg\u00farate de ponerle un nombre f\u00e1cil de recordar a tu tabla en la pesta\u00f1a de dise\u00f1o, por ejemplo, \u00abTablaVentas\u00bb.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-cdf752f2\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 2: Encontrar coincidencias con HALLAR y ESNUMERO<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-bdafde27 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h48m12s645-1024x191.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h48m12s645.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h48m12s645.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h48m12s645-1024x191.avif\" alt=\"Uso de funci\u00f3n ESNUMERO y HALLAR en Excel.\" class=\"uag-image-27688\" width=\"1024\" height=\"191\" title=\"F\u00f3rmulas de b\u00fasqueda b\u00e1sica.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Vamos a empezar de a poco. Primero, necesitamos que Excel identifique si la palabra que escribimos en nuestro buscador existe dentro de la columna de productos. Para esto, utilizaremos dos funciones anidadas.<\/p>\n\n\n\n<p>La funci\u00f3n <code>HALLAR<\/code> nos dir\u00e1 en qu\u00e9 posici\u00f3n se encuentra el texto que buscamos. Sin embargo, si no lo encuentra, arrojar\u00e1 un error. Para evitar ese error fatal y obtener un resultado m\u00e1s limpio, la envolvemos en la funci\u00f3n <code>ESNUMERO<\/code>. De esta forma, Excel nos devolver\u00e1 \u00abVERDADERO\u00bb si encuentra el producto y \u00abFALSO\u00bb si no lo encuentra.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-fb1b185c\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 3: Traer los resultados con la funci\u00f3n FILTRAR<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-0d316053 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h51m05s764-1024x102.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h51m05s764.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h51m05s764.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h51m05s764-1024x102.avif\" alt=\"Funci\u00f3n FILTRAR en Excel para buscar datos.\" class=\"uag-image-27690\" width=\"1024\" height=\"102\" title=\"Extraer datos con FILTRAR.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Ahora que sabemos cu\u00e1les filas contienen nuestro producto (las que dicen \u00abVERDADERO\u00bb), vamos a extraer esos datos completos. Aqu\u00ed es donde entra la magia de las matrices din\u00e1micas.<\/p>\n\n\n\n<p>Usaremos la funci\u00f3n <code>FILTRAR<\/code>. Esta funci\u00f3n nos pide la matriz (toda nuestra \u00abTablaVentas\u00bb), lo que queremos incluir (la f\u00f3rmula de \u00abVERDADERO\u00bb o \u00abFALSO\u00bb del paso anterior) y qu\u00e9 mensaje mostrar si no hay resultados, como por ejemplo: \u00abNo hay datos\u00bb.<\/p>\n\n\n\n<p><em>Nota importante:<\/em> La funci\u00f3n FILTRAR est\u00e1 disponible en las versiones m\u00e1s recientes, por lo que si quieres aprovecharla al m\u00e1ximo, es recomendable contar con <a href=\"https:\/\/support.microsoft.com\/es-es\/office\/funci%C3%B3n-filtrar-f4f7cb66-82eb-4767-8f7c-4877ad80c759\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 365<\/a> (enlace externo a la documentaci\u00f3n oficial de Microsoft).<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-cf0295b6\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 4: B\u00fasqueda unificada concatenando columnas<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-909a4b2b wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h55m37s786-1024x107.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h55m37s786-scaled.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h55m37s786-scaled.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h55m37s786-1024x107.avif\" alt=\"Concatenar columnas en Excel para buscador unificado.\" class=\"uag-image-27692\" width=\"1024\" height=\"107\" title=\"Concatenar datos de b\u00fasqueda.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Hasta ahora, nuestro <strong>buscador din\u00e1mico en Excel<\/strong> solo busca productos. \u00bfPero qu\u00e9 pasa si escribimos el nombre de un mes o de un cliente? Para que la celda de b\u00fasqueda sea inteligente y busque en varias columnas al mismo tiempo, debemos concatenar (unir) los campos.<\/p>\n\n\n\n<p>Usando el s\u00edmbolo de <em>Ampersand<\/em> (<code>&amp;<\/code>), podemos unir la columna de producto, la de mes y la de cliente dentro de nuestra funci\u00f3n <code>HALLAR<\/code>. De esta forma, si escribes \u00abAbril\u00bb o \u00abHotel\u00bb, el sistema revisar\u00e1 todas esas columnas combinadas y te traer\u00e1 el resultado exacto.<\/p>\n\n\n\n<p>Si deseas profundizar en c\u00f3mo mejorar la presentaci\u00f3n de estos datos, te sugiero revisar mi <a href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos-en-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">tutorial sobre c\u00f3mo ordenar y dar formato a celdas en Excel<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-02f02cec\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 5: Crear un buscador avanzado en Excel con varios criterios<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-7a37bb19 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h59m03s927-1024x93.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h59m03s927-scaled.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h59m03s927-scaled.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-09h59m03s927-1024x93.avif\" alt=\"M\u00faltiples criterios en buscador avanzado de Excel.\" class=\"uag-image-27694\" width=\"1024\" height=\"93\" title=\"Buscador con varios criterios.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">Si necesitas ser mucho m\u00e1s espec\u00edfico, por ejemplo, buscar \u00abMonitores\u00bb que se vendieron en \u00abAbril\u00bb al cliente \u00abHotel\u00bb, requerimos celdas de b\u00fasqueda independientes.<\/p>\n\n\n\n<p>Para lograr este buscador avanzado en Excel, calculamos la coincidencia de cada columna por separado (Mes, Producto, Cliente) asegur\u00e1ndonos de que est\u00e9n entre par\u00e9ntesis. Luego, en lugar de concatenar, multiplicamos esas condiciones usando un asterisco (<code>*<\/code>). En la l\u00f3gica de Excel, esto funciona como un operador \u00abY\u00bb, obligando a que se cumplan todos los criterios simult\u00e1neamente para mostrar el resultado.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-174c22b2\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 6: Mostrar columnas espec\u00edficas con ELEGIRCOLS<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-9b8826ea wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-10h04m58s745-1024x75.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-10h04m58s745-scaled.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-10h04m58s745-scaled.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/04\/vlcsnap-2026-04-01-10h04m58s745-1024x75.avif\" alt=\"Funci\u00f3n ELEGIRCOLS en Microsoft 365.\" class=\"uag-image-27695\" width=\"1024\" height=\"75\" title=\"Extraer columnas espec\u00edficas en Excel.\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">A veces, tu tabla original puede tener 20 columnas, pero t\u00fa solo quieres ver 3 o 4 en tus resultados. Si cuentas con Microsoft 365, puedes envolver todo tu trabajo previo dentro de la funci\u00f3n <code>ELEGIRCOLS<\/code>.<\/p>\n\n\n\n<p>Solo necesitas indicar tu matriz (la f\u00f3rmula <code>FILTRAR<\/code> que ya hicimos) y escribir los n\u00fameros de las columnas que deseas extraer, separados por punto y coma (por ejemplo, 1; 3; 6; 7). \u00a1Y listo! Tu informaci\u00f3n se ver\u00e1 mucho m\u00e1s limpia y profesional. Para dominar otras herramientas modernas, no olvides visitar mi <a href=\"https:\/\/dostinhurtado.com\/site\/tutoriales\/\" target=\"_blank\" rel=\"noreferrer noopener\">secci\u00f3n completa de tutoriales de ofim\u00e1tica<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-687f9fc5\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Crear un <strong>buscador din\u00e1mico en Excel<\/strong> puede parecer complejo al ver la f\u00f3rmula terminada, pero al construirlo paso a paso, cada funci\u00f3n tiene una raz\u00f3n de ser l\u00f3gica y comprensible. Desde organizar tus datos en una tabla hasta aplicar matrices din\u00e1micas, has aprendido a darle a tus hojas de c\u00e1lculo un comportamiento de software profesional.<\/p>\n\n\n\n<p>An\u00edmate a aplicar este panel de b\u00fasqueda en tus proyectos personales o en tu trabajo. \u00a1Te garantizo que te facilitar\u00e1 la vida enormemente! Si este tutorial te fue de utilidad, te invito a seguir explorando nuestros cursos y compartir este conocimiento con quien lo necesite.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-5cb27e6e\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-383e6a5a uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b7f4ae10 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 versi\u00f3n necesito para hacer un buscador din\u00e1mico en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Las funciones b\u00e1sicas como HALLAR y ESNUMERO funcionan en versiones antiguas. Sin embargo, para que el buscador extraiga y muestre los datos autom\u00e1ticamente, necesitas la funci\u00f3n FILTRAR, disponible desde Excel 2021 o Microsoft 365.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-54e0f54f \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPor qu\u00e9 mi f\u00f3rmula me arroja el error \u00abhttps:\/\/www.google.com\/search?q=%23\u00a1CALC!\u00bb?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Este error en la funci\u00f3n FILTRAR suele aparecer cuando tu b\u00fasqueda no arroja ning\u00fan resultado. Puedes solucionarlo rellenando el \u00faltimo argumento de la funci\u00f3n FILTRAR con un texto entre comillas, como \u00abNo hay datos\u00bb.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-1e7c226d \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo buscar datos usando min\u00fasculas o may\u00fasculas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed. La funci\u00f3n HALLAR no distingue entre letras may\u00fasculas y min\u00fasculas, por lo que tu panel de b\u00fasqueda en Excel funcionar\u00e1 a la perfecci\u00f3n sin importar c\u00f3mo escribas la palabra.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b11d897f \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 hago si quiero buscar en una tabla de otra hoja?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Es totalmente posible. Solo aseg\u00farate de haber convertido tus datos en \u00abTabla\u00bb (Ctrl + T) y de haberle puesto un nombre. As\u00ed, podr\u00e1s llamar a la tabla desde cualquier hoja de tu libro de Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-5cc0f463 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfLa funci\u00f3n ELEGIRCOLS sirve en Excel 2019?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No, la funci\u00f3n ELEGIRCOLS es muy reciente y actualmente es exclusiva para los usuarios suscritos a Microsoft 365. Si tienes versiones anteriores, el buscador traer\u00e1 todas las columnas de tu tabla original.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Buscador din\u00e1mico en Excel: Gu\u00eda paso a paso \u00bfTe has enfrentado alguna vez a una tabla con miles de registros [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":27563,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[562,225,232,277,539,570,486],"class_list":["post-27562","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales-excel","tag-curso","tag-excel","tag-facil","tag-gratis","tag-gratuito","tag-recomendado","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Buscador din\u00e1mico en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Buscador din\u00e1mico en Excel\" \/>\n<meta property=\"og:description\" content=\"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-06T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292\"},\"headline\":\"Buscador din\u00e1mico en Excel\",\"datePublished\":\"2026-04-06T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\"},\"wordCount\":874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif\",\"keywords\":[\"Curso\",\"Excel\",\"Facil\",\"Gratis\",\"Gratuito\",\"recomendado\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\",\"name\":\"Buscador din\u00e1mico en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif\",\"datePublished\":\"2026-04-06T17:30:00+00:00\",\"description\":\"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif\",\"width\":500,\"height\":375,\"caption\":\"Busca de la mejor manera en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Buscador din\u00e1mico en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/daniel\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Buscador din\u00e1mico en Excel - Dostin Hurtado","description":"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Buscador din\u00e1mico en Excel","og_description":"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2026-04-06T17:30:00+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292"},"headline":"Buscador din\u00e1mico en Excel","datePublished":"2026-04-06T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/"},"wordCount":874,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif","keywords":["Curso","Excel","Facil","Gratis","Gratuito","recomendado","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/","name":"Buscador din\u00e1mico en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif","datePublished":"2026-04-06T17:30:00+00:00","description":"Aprende a crear un buscador din\u00e1mico en Excel. Filtra datos por m\u00faltiples criterios f\u00e1cilmente con las funciones HALLAR, ESNUMERO y FILTRAR.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif","width":500,"height":375,"caption":"Busca de la mejor manera en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscador-dinamico-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Buscador din\u00e1mico en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775020468","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/02\/Buscador-Inteligente-en-Excel-Miniatura-02-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Buscador din\u00e1mico en Excel: Gu\u00eda paso a paso \u00bfTe has enfrentado alguna vez a una tabla con miles de registros [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=27562"}],"version-history":[{"count":8,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27562\/revisions"}],"predecessor-version":[{"id":27696,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/27562\/revisions\/27696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27563"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=27562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=27562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=27562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}