{"id":20315,"date":"2023-07-26T09:46:50","date_gmt":"2023-07-26T14:46:50","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=20315"},"modified":"2025-04-10T11:15:51","modified_gmt":"2025-04-10T16:15:51","slug":"buscarx-la-nueva-funcion-de-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/","title":{"rendered":"Funci\u00f3n BUSCARX en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-funcion-buscarx-en-excel-la-mejor-alternativa-a-buscarv-y-buscarh\">Funci\u00f3n BUSCARX en Excel: La Mejor Alternativa a BUSCARV y BUSCARH<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La Funci\u00f3n BUSCARX en Exce<strong>l<\/strong> es una de las herramientas m\u00e1s poderosas y vers\u00e1tiles que han llegado a las versiones m\u00e1s recientes de Excel. En este art\u00edculo, te explicaremos c\u00f3mo funciona, por qu\u00e9 es una mejor opci\u00f3n que BUSCARV y BUSCARH, y c\u00f3mo puedes aprovecharla al m\u00e1ximo.<\/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=\"BuscarX la Nueva Funci\u00f3n de Excel \u00bfMejor que BuscarV y BuscarH? \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/QG0s5iUBWWA?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<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left wp-block-paragraph\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-52b417\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-558dff ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/Material-de-apoyo-BuscarX.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-que-es-la-funcion-buscarx-en-excel\">\u00bfQu\u00e9 es la Funci\u00f3n BUSCARX en Excel?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La <strong>Funci\u00f3n BUSCARX en Excel<\/strong> permite realizar b\u00fasquedas dentro de una tabla sin importar la posici\u00f3n de la columna que contiene los valores deseados. A diferencia de BUSCARV y BUSCARH, no es necesario modificar la estructura de la tabla para obtener resultados.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ventajas de la Funci\u00f3n BUSCARX en Excel<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Permite buscar valores sin importar su posici\u00f3n en la tabla.<\/li>\n\n\n\n<li>Funciona tanto en b\u00fasquedas verticales como horizontales.<\/li>\n\n\n\n<li>Evita errores al devolver un valor personalizado si no encuentra coincidencias.<\/li>\n\n\n\n<li>Est\u00e1 disponible en versiones recientes de Excel y en la versi\u00f3n en l\u00ednea.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfC\u00f3mo Usar la Funci\u00f3n BUSCARX en Excel? Ejemplos Pr\u00e1cticos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A continuaci\u00f3n, veremos ejemplos pr\u00e1cticos para entender c\u00f3mo utilizar la funci\u00f3n BUSCARX en Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Buscar un Valor en una Tabla<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"c5d1e6\" data-has-transparency=\"true\" style=\"--dominant-color: #c5d1e6;\" fetchpriority=\"high\" decoding=\"async\" width=\"589\" height=\"98\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-5-png.avif\" alt=\"F\u00f3rmula BUSCARX en Excel mostrando la b\u00fasqueda de una ciudad basada en el c\u00f3digo de sucursal.\" class=\"wp-image-24532 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-5-png.avif 589w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-5-300x50.avif 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Si tenemos una lista de sucursales con c\u00f3digos y ciudades, podemos encontrar la ciudad asociada a un c\u00f3digo de la siguiente manera:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=BUSCARX(A2, A:A, B:B, \"No encontrado\")<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. Evitar Errores al No Encontrar un Valor<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"cad4e7\" data-has-transparency=\"true\" style=\"--dominant-color: #cad4e7;\" decoding=\"async\" width=\"674\" height=\"90\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-6-png.avif\" alt=\"F\u00f3rmula BUSCARX en Excel mostrando un mensaje de error personalizado cuando no se encuentra un valor.\" class=\"wp-image-24533 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-6-png.avif 674w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-6-300x40.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-6-600x80.avif 600w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">BUSCARX permite definir un mensaje personalizado si el valor no existe, en lugar de mostrar un error.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=BUSCARX(A2, A:A, B:B, \"No existe\")<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"cdd6e8\" data-has-transparency=\"true\" style=\"--dominant-color: #cdd6e8;\" decoding=\"async\" width=\"693\" height=\"95\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-7-png.avif\" alt=\"\" class=\"wp-image-24534 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-7-png.avif 693w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-7-300x41.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-7-600x82.avif 600w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. Buscar de Forma Horizontal (Reemplazo de BUSCARH)<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"bac8e1\" data-has-transparency=\"true\" style=\"--dominant-color: #bac8e1;\" loading=\"lazy\" decoding=\"async\" width=\"554\" height=\"84\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-8-png.avif\" alt=\"F\u00f3rmula BUSCARX en Excel buscando un nombre de forma horizontal a partir de un mes.\" class=\"wp-image-24536 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-8-png.avif 554w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/image-8-300x45.avif 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><figcaption class=\"wp-element-caption\">Uso de BUSCARX en Excel para b\u00fasquedas horizontales con un mensaje de error personalizado.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Si tenemos los datos en filas en lugar de columnas, la funci\u00f3n BUSCARX en Excel tambi\u00e9n funciona sin problemas:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=BUSCARX(D2, E1:J1, E2:J2, \"No encontrado\")<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfPor Qu\u00e9 Reemplazar BUSCARV y BUSCARH con BUSCARX?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">BUSCARX supera a BUSCARV y BUSCARH en varios aspectos:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Flexibilidad:<\/strong> No es necesario reorganizar las columnas.<\/li>\n\n\n\n<li><strong>Mayor Precisi\u00f3n:<\/strong> Permite definir valores predeterminados cuando no hay coincidencias.<\/li>\n\n\n\n<li><strong>Menos Errores:<\/strong> Reduce el uso de f\u00f3rmulas adicionales como SI.ERROR.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udce2 <strong>\u00a1Domina Excel y lleva tus habilidades al siguiente nivel!<\/strong> Si quieres aprender a crear f\u00f3rmulas avanzadas, automatizar tareas con macros y manejar grandes vol\u00famenes de datos como un experto, un <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> es la mejor opci\u00f3n. No pierdas m\u00e1s tiempo intentando resolver problemas por tu cuenta, aprende de manera estructurada y eficiente. \u00a1Inscr\u00edbete ahora y convi\u00e9rtete en un maestro de Excel!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pasos para Comprar Excel con Descuento<\/h3>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Visita el sitio de <a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a> y selecciona Excel 2021.<\/li>\n\n\n\n<li>A\u00f1\u00e1delo al carrito y aplica el cup\u00f3n <strong>DH66<\/strong>.<\/li>\n\n\n\n<li>Finaliza la compra y descarga el software.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-763f98b9 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-6d0ef47c \" 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>1. \u00bfEn qu\u00e9 versiones de Excel est\u00e1 disponible la funci\u00f3n BUSCARX?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n BUSCARX solo est\u00e1 disponible en <strong>Excel 2021, Excel 365 y la versi\u00f3n en l\u00ednea<\/strong>. No est\u00e1 presente en Excel 2019 ni versiones anteriores.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-d03b51da \" 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>2. \u00bfCu\u00e1l es la diferencia entre BUSCARX y BUSCARV?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La principal diferencia es que <strong>BUSCARX permite buscar valores en cualquier direcci\u00f3n<\/strong>, mientras que <strong>BUSCARV solo permite b\u00fasquedas verticales y requiere que la columna de b\u00fasqueda est\u00e9 a la izquierda<\/strong>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6182ada9 \" 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>3. \u00bfPuedo usar BUSCARX en Excel para Mac?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, la funci\u00f3n BUSCARX est\u00e1 disponible en Excel para Mac si tienes la versi\u00f3n 365 o 2021.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-5e73c340 \" 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>4. \u00bfQu\u00e9 hacer si BUSCARX no encuentra un valor?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes personalizar el mensaje de error utilizando el cuarto argumento de la funci\u00f3n, por ejemplo:<br><code><strong>=BUSCARX(A2, A:A, B:B, \"No encontrado\")<\/strong><\/code><\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8383d258 \" 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>5. \u00bfPuedo usar BUSCARX en combinaci\u00f3n con otras funciones?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, BUSCARX se puede combinar con funciones como <strong>SUMA, CONCATENAR o SI<\/strong> para obtener resultados m\u00e1s avanzados.<\/p><\/div><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><strong>Conclusi\u00f3n<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La <strong>Funci\u00f3n BUSCARX en Excel<\/strong> es una mejora significativa respecto a BUSCARV y BUSCARH, ofreciendo mayor flexibilidad, precisi\u00f3n y facilidad de uso. Su capacidad para buscar datos sin restricciones de posici\u00f3n y devolver valores personalizados en caso de errores la convierten en una herramienta esencial para cualquier usuario de Excel. Si a\u00fan utilizas versiones antiguas, considera actualizar a Excel 2021 o Excel 365 para aprovechar esta poderosa funci\u00f3n y mejorar tu productividad.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Optimiza el flujo de trabajo con la poderosa funci\u00f3n BUSCARX, si son nuevo usando Excel o quieren aprender a usar esta nueva funci\u00f3n este es el tutorial que necesitan. Con esta funci\u00f3n podremos realizar b\u00fasquedas y recuperar datos espec\u00edficos de manera eficiente, mucho m\u00e1s f\u00e1cil de lo que nos tiene acostumbrados otras funciones.<\/p>\n","protected":false},"author":4,"featured_media":20316,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","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":[730,562,226,568,277,539,570,486,2531],"class_list":["post-20315","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-buscarv","tag-curso","tag-excel-avanzado","tag-funciones-basicas","tag-gratis","tag-gratuito","tag-recomendado","tag-tutorial","tag-tutorial-de-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n BUSCARX en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.\" \/>\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\/buscarx-la-nueva-funcion-de-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n BUSCARX en Excel - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T14:46:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-10T16:15:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg\" \/>\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=\"4 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\\\/buscarx-la-nueva-funcion-de-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Funci\u00f3n BUSCARX en Excel\",\"datePublished\":\"2023-07-26T14:46:50+00:00\",\"dateModified\":\"2025-04-10T16:15:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/\"},\"wordCount\":567,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/miniatura-web.jpg\",\"keywords\":[\"BuscarV\",\"Curso\",\"Excel Avanzado\",\"Funciones b\u00e1sicas\",\"Gratis\",\"Gratuito\",\"recomendado\",\"Tutorial\",\"tutorial de excel\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/\",\"name\":\"Funci\u00f3n BUSCARX en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/miniatura-web.jpg\",\"datePublished\":\"2023-07-26T14:46:50+00:00\",\"dateModified\":\"2025-04-10T16:15:51+00:00\",\"description\":\"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/miniatura-web.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/miniatura-web.jpg\",\"width\":500,\"height\":375,\"caption\":\"Funcion buscarx en excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/buscarx-la-nueva-funcion-de-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n BUSCARX 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\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"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\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"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\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n BUSCARX en Excel - Dostin Hurtado","description":"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.","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\/buscarx-la-nueva-funcion-de-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n BUSCARX en Excel - Dostin Hurtado","og_description":"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2023-07-26T14:46:50+00:00","article_modified_time":"2025-04-10T16:15:51+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Funci\u00f3n BUSCARX en Excel","datePublished":"2023-07-26T14:46:50+00:00","dateModified":"2025-04-10T16:15:51+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/"},"wordCount":567,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg","keywords":["BuscarV","Curso","Excel Avanzado","Funciones b\u00e1sicas","Gratis","Gratuito","recomendado","Tutorial","tutorial de excel"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/","name":"Funci\u00f3n BUSCARX en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg","datePublished":"2023-07-26T14:46:50+00:00","dateModified":"2025-04-10T16:15:51+00:00","description":"Aprende a usar la funci\u00f3n BUSCARX en Excel para reemplazar BUSCARV y BUSCARH. Descubre sus ventajas y c\u00f3mo aprovecharla al m\u00e1ximo.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg","width":500,"height":375,"caption":"Funcion buscarx en excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/buscarx-la-nueva-funcion-de-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n BUSCARX 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\/6bc1fbb1a73635ac2e186182146d04e9"},"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\/6bc1fbb1a73635ac2e186182146d04e9","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\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web.jpg",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/07\/miniatura-web-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"Optimiza el flujo de trabajo con la poderosa funci\u00f3n BUSCARX, si son nuevo usando Excel o quieren aprender a usar esta nueva funci\u00f3n este es el tutorial que necesitan. Con esta funci\u00f3n podremos realizar b\u00fasquedas y recuperar datos espec\u00edficos de manera eficiente, mucho m\u00e1s f\u00e1cil de lo que nos tiene acostumbrados otras funciones.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20315","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=20315"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20315\/revisions"}],"predecessor-version":[{"id":25317,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20315\/revisions\/25317"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/20316"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=20315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=20315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=20315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}