{"id":47365,"date":"2021-12-05T18:06:51","date_gmt":"2021-12-06T00:06:51","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=47365"},"modified":"2025-01-03T17:37:38","modified_gmt":"2025-01-03T23:37:38","slug":"funcion-buscarx","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/funcion-buscarx.html","title":{"rendered":"Funcion BuscarX"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como Aplicar la Funcion BuscarX<\/h1>\n<p>Estas listo para aprender a utilizar la Funcion Buscarx ? Te gustar\u00eda conocer la sintaxis de la nueva funcion BuscarX ?<\/p>\n<p><span><img decoding=\"async\" alt=\"funcion buscarx\" data-id=\"47408\" width=\"598\" data-init-width=\"612\" height=\"112\" data-init-height=\"115\" title=\"Funcion BuscarX\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Funcion-BuscarX.png\" data-width=\"598\" data-height=\"112\" style=\"aspect-ratio: auto 612 \/ 115;\"><\/span><\/p>\n<p>Hola soy Roger Perez y en este articulo te voy a compartir la Sintaxis de la Funcion BuscarX y su forma de aplicacion.<\/p>\n<p>Estas listo?<\/p>\n<p>Comencemos:<\/p>\n<h2 style=\"text-align: center;\">Sintaxis de la Funcion BuscarX<\/h2>\n<p>Para comenzar, lo primero que debemos de conocer es la sintaxis de la Funcion BuscarX, a continuaci\u00f3n te dejo la sintaxis:<\/p>\n<blockquote><p>=BUSCARX(Valor_buscado;matriz_buscado;matriz_devuelta;[si_no_se_encuentra];[modo_de_coincidencia];[modo_de_busqueda])<\/p><\/blockquote>\n<p>Listo, ahora que ya conoces la sintaxis, vamos a ver un caso practico de como utilizar la Funcion Buscarx.<\/p>\n<h2 style=\"text-align: center;\">Caso practico de como Aplicar la Funcion BuscarX<\/h2>\n<p>Para comenzar a mostrarte los pasos de como aplicar &nbsp;la funci\u00f3n buscarx, te invito a que descargues el siguiente archivo:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47415\" target=\"_blank\" rel=\"noopener\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47415\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n<p>Ya descargaste el archivo ?<\/p>\n<p>Si tu respuesta es si, entonces el siguiente paso es abrir el archivo.<\/p>\n<p>Ahora, tan solo ub\u00edcate en la celda D7 y podr\u00e1s notar que para buscar un valor a la izquierda de una matriz, utilizamos la funci\u00f3n INDICE y COINCIDIR.<\/p>\n<p>Pero con la nueva funci\u00f3n, esta extensa formula, se resumir\u00e1 totalmente.<\/p>\n<p>Comencemos:<\/p>\n<p>Seleccionamos la celda D6 y dentro de este escribimos la siguiente formula:<\/p>\n<blockquote><p>&nbsp;=BUSCARX(G7;MASTERSR[R&amp;F-EP];MASTERSR[DATE])<\/p><\/blockquote>\n<h3 style=\"text-align: center;\">Significado de la Sintaxis de la formula<\/h3>\n<p>Una vez escrito la formula, pulsamos enter y te mostrara n\u00fameros equivalente a la fecha:<\/p>\n<p><span><img decoding=\"async\" alt=\"\" data-id=\"47423\" width=\"204\" data-init-width=\"204\" height=\"109\" data-init-height=\"109\" title=\"Formula Buscarx\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Formula-Buscarx.png\" data-width=\"204\" data-height=\"109\" style=\"aspect-ratio: auto 204 \/ 109;\" data-init- data-><\/span><\/p>\n<p>Ahora, tan solo le aplicas formato fecha y veras que te mostrara la fecha. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/ejemplo-formatos-celda-fecha\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Pulsa clic aqu\u00ed para ver como aplicar Formato de Fecha<\/a>.<\/p>\n<p>Ahora si, veamos que significa cada sintaxis:<\/p>\n<ul>\n<li>La G7 indica el valor a buscar<\/li>\n<li>MASTERSR[R&amp;F-EP], este hace referencia a la tabla MASTERSR y la [R&amp;F-EP] hace referencia a la columna que contiene el valor buscado, en este caso el numero del documento.<\/li>\n<li>Y MASTERSR[DATE], hace referencia a la tabla y a la columna del cual querremos mostrar el resultado correspondiente, en este caso la Fecha.<\/li>\n<\/ul>\n<p>Con estos pasos pasos ya hemos aplicado la formula Buscarx para buscar un valor a la izquierda de una tabla, de la misma forma puedes buscar valores a la derecha de la tabla.<\/p>\n<p>Para terminar comparemos las formulas:<\/p>\n<h2 style=\"text-align: center;\">Comparaci\u00f3n de formulas<\/h2>\n<p>Al iniciar te mostr\u00e9 una formula, el cual es extenso, y a continuaci\u00f3n puedes comparar que tal queda al utilizar BuscarX:<\/p>\n<p><em><strong>Primera Formula: S<\/strong><\/em>e utiliza 2 Funciones para conseguir el objetivo.<\/p>\n<blockquote><p>=SI(G7&lt;&gt;\u00bb\u00bb;INDICE(MASTERSR[DATE];COINCIDIR(&#8216;ACCEPT OR DECLINE&#8217;!G7;MASTERSR[R&amp;F-EP]));\u00bb\u00bb)<\/p><\/blockquote>\n<p><em><strong>Segunda Formula:<\/strong><\/em> Se utiliza solo la Funcion BUSCARX, para conseguir el objetivo<\/p>\n<blockquote><p>=BUSCARX(G7;MASTERSR[R&amp;F-EP];MASTERSR[DATE])<\/p><\/blockquote>\n<p>La ultima formula es la mejor, corto y conciso, no olvides, que BuscarX reemplaza a BuscarV, ahora puedes buscar valores a la Izquierda o Derecha de una matriz con facilidad.<\/p>\n<p>Que tal te pareci\u00f3 el articulo de hoy ? Te gusto ?<\/p>\n<p>Si te gusto, comp\u00e1rtelo con tus amigos de facebook, pulsando clic en el bot\u00f3n <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">Compartir<\/a>:<\/p>\n<h2>Preguntas Frecuentes de la Funci\u00f3n BuscarX<\/h2>\n<h3>\u00bfC\u00f3mo se utiliza la funci\u00f3n buscarv?<\/h3>\n<h3>\u00bfC\u00f3mo se utiliza la funci\u00f3n buscarh en Excel?<\/h3>\n<h3>\u00bfC\u00f3mo usar la funci\u00f3n coincidir en Excel?<\/h3>\n<h3>\u00bfC\u00f3mo funciona la funci\u00f3n de b\u00fasqueda en Excel?<\/h3>\n<p>Cualquier duda o pregunta, tan solo escr\u00edbenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p>\n<p>Saludos,<\/p>\n<p><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como Aplicar la Funcion BuscarX Estas listo para aprender a utilizar la Funcion Buscarx ? Te gustar\u00eda conocer la sintaxis de la nueva funcion BuscarX ? Hola soy Roger Perez y en este articulo te voy a compartir la Sintaxis de la Funcion BuscarX y su forma de aplicacion. Estas listo? Comencemos: Sintaxis de la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":47408,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-17e60e63ea8\">Como Aplicar la Funcion BuscarX<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8cdb3a37\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8cdb3a34\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Estas listo para aprender a utilizar la Funcion Buscarx ? Te gustar\u00eda conocer la sintaxis de la nueva funcion BuscarX ?<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-17d8ce597b7\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-47408\" alt=\"funcion buscarx\" data-id=\"47408\" width=\"598\" data-init-width=\"612\" height=\"112\" data-init-height=\"115\" title=\"Funcion BuscarX\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Funcion-BuscarX.png\" data-width=\"598\" data-height=\"112\" style=\"aspect-ratio: auto 612 \/ 115;\"><\/span><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8ce6ae42\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8ce6ae3f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Hola soy Roger Perez y en este articulo te voy a compartir la Sintaxis de la Funcion BuscarX y su forma de aplicacion.<\/p><p>Estas listo?<\/p><p>Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" class=\"\">Sintaxis de la Funcion BuscarX<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8ce8ceee\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8ce8ceeb\"><div class=\"thrv_wrapper thrv_text_element\"><p>Para comenzar, lo primero que debemos de conocer es la sintaxis de la Funcion BuscarX, a continuaci\u00f3n te dejo la sintaxis:<\/p><blockquote class=\"\">=BUSCARX(Valor_buscado;matriz_buscado;matriz_devuelta;[si_no_se_encuentra];[modo_de_coincidencia];[modo_de_busqueda])<\/blockquote><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8d043784\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8d043781\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Listo, ahora que ya conoces la sintaxis, vamos a ver un caso practico de como utilizar la Funcion Buscarx.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" style=\"text-align: center;\">Caso practico de como Aplicar la Funcion BuscarX<\/h2><\/div><div class=\"thrv_responsive_video thrv_wrapper tcb-lazy-load tcb-lazy-load-youtube\" data-type=\"youtube\" data-rel=\"0\" data-modestbranding=\"0\" data-aspect-ratio=\"16:9\" data-aspect-ratio-default=\"0\" data-float-position=\"top-left\" data-float-width-d=\"300px\" data-float-padding1-d=\"25px\" data-float-padding2-d=\"25px\" data-float-visibility=\"mobile\" data-url=\"https:\/\/youtu.be\/4Tn4L6nwJQc\" data-float=\"true\" style=\"\" data-css=\"tve-u-190dcf58080\" id=\"video\">\n\t\n\n\t<div class=\"tve_responsive_video_container\" style=\"padding-bottom: 56.25%;\">\n\t\t<div class=\"tcb-video-float-container\"><div class=\"video_overlay\"><\/div><iframe title=\"Como Aplicar la Funcion BuscarX en excel\" class=\"tcb-responsive-video\" data-code=\"4Tn4L6nwJQc\" data-hash=\"undefined\" data-provider=\"youtube\" frameborder=\"0\" allowfullscreen=\"\" loading=\"lazy\" data-origwidth=\"\" data-origheight=\"\" style=\"width: 721px;\" data-gtm-yt-inspected-6=\"true\" id=\"848061147\" data-src=\"https:\/\/www.youtube.com\/embed\/4Tn4L6nwJQc?rel=0&amp;modestbranding=0&amp;controls=1&amp;showinfo=1&amp;fs=1&amp;wmode=transparent&amp;enablejsapi=1\"><\/iframe><\/div>\n\t<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8fedc8d1\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8fedc8cf\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Para comenzar a mostrarte los pasos de como aplicar &nbsp;la funci\u00f3n buscarx, te invito a que descargues el siguiente archivo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d8fed3a5d\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-17d8fed3a5e\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d8fed3a5a\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-17d8fed3a5c\" style=\"--tcb-col-el-width: 682.797;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-17d8fed3a56\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47415\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-17d8fed3a54\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-17d8fed3a57\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-17d8fed3a59\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47415\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve-viewport-triggered\" data-css=\"tve-u-17d8fed3a5f\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d9059cd45\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d9059cd41\"><div class=\"thrv_wrapper thrv_text_element\"><p>Ya descargaste el archivo ?<\/p><p>Si tu respuesta es si, entonces el siguiente paso es abrir el archivo.<\/p><p>Ahora, tan solo ub\u00edcate en la celda D7 y podr\u00e1s notar que para buscar un valor a la izquierda de una matriz, utilizamos la funci\u00f3n INDICE y COINCIDIR.<\/p><p>Pero con la nueva funci\u00f3n, esta extensa formula, se resumir\u00e1 totalmente.<\/p><p>Comencemos:<\/p><p>Seleccionamos la celda D6 y dentro de este escribimos la siguiente formula:<\/p><blockquote class=\"\">&nbsp;=BUSCARX(G7;MASTERSR[R&amp;F-EP];MASTERSR[DATE])<\/blockquote><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"text-align: center;\" class=\"\">Significado de la Sintaxis de la formula<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d9092f64e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d9092f64b\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Una vez escrito la formula, pulsamos enter y te mostrara n\u00fameros equivalente a la fecha:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-17d909fde85\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-47423\" alt=\"\" data-id=\"47423\" width=\"204\" data-init-width=\"204\" height=\"109\" data-init-height=\"109\" title=\"Formula Buscarx\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Formula-Buscarx.png\" data-width=\"204\" data-height=\"109\" style=\"aspect-ratio: auto 204 \/ 109;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90a3f27b\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90a3f278\"><div class=\"thrv_wrapper thrv_text_element\"><p>Ahora, tan solo le aplicas formato fecha y veras que te mostrara la fecha. <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/ejemplo-formatos-celda-fecha\" target=\"_blank\" class=\"\" style=\"outline: none;\">Pulsa clic aqu\u00ed para ver como aplicar Formato de Fecha<\/a>.<\/p><p>Ahora si, veamos que significa cada sintaxis:<\/p><ul class=\"\"><li class=\"\">La G7 indica el valor a buscar<\/li><li class=\"\">MASTERSR[R&amp;F-EP], este hace referencia a la tabla MASTERSR y la [R&amp;F-EP] hace referencia a la columna que contiene el valor buscado, en este caso el numero del documento.<\/li><li class=\"\">Y MASTERSR[DATE], hace referencia a la tabla y a la columna del cual querremos mostrar el resultado correspondiente, en este caso la Fecha.<\/li><\/ul><p>Con estos pasos pasos ya hemos aplicado la formula Buscarx para buscar un valor a la izquierda de una tabla, de la misma forma puedes buscar valores a la derecha de la tabla.<\/p><p>Para terminar comparemos las formulas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" class=\"\">Comparaci\u00f3n de formulas<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90acc2c5\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90acc2c2\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Al iniciar te mostr\u00e9 una formula, el cual es extenso, y a continuaci\u00f3n puedes comparar que tal queda al utilizar BuscarX:<\/p><p><em><strong>Primera Formula: S<\/strong><\/em>e utiliza 2 Funciones para conseguir el objetivo.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90b20214\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90acc2c2\"><div class=\"thrv_wrapper thrv_text_element\"><blockquote class=\"\">=SI(G7&lt;&gt;\"\";INDICE(MASTERSR[DATE];COINCIDIR('ACCEPT OR DECLINE'!G7;MASTERSR[R&amp;F-EP]));\"\")<\/blockquote><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90b0bb2d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90b0bb2a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p><em><strong>Segunda Formula:<\/strong><\/em> Se utiliza solo la Funcion BUSCARX, para conseguir el objetivo<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90b1737c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90b17379\"><div class=\"thrv_wrapper thrv_text_element\"><blockquote class=\"\">=BUSCARX(G7;MASTERSR[R&amp;F-EP];MASTERSR[DATE])<\/blockquote><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90b4b5a8\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90b4b5a4\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>La ultima formula es la mejor, corto y conciso, no olvides, que BuscarX reemplaza a BuscarV, ahora puedes buscar valores a la Izquierda o Derecha de una matriz con facilidad.<\/p><p>Que tal te pareci\u00f3 el articulo de hoy ? Te gusto ?<\/p><p>Si te gusto, comp\u00e1rtelo con tus amigos de facebook, pulsando clic en el bot\u00f3n <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">Compartir<\/a>:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-17d90b9550d\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-17d90b9550b\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2>Preguntas Frecuentes de la Funci\u00f3n BuscarX<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3>\u00bfC\u00f3mo se utiliza la funci\u00f3n buscarv?<\/h3><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3>\u00bfC\u00f3mo se utiliza la funci\u00f3n buscarh en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3>\u00bfC\u00f3mo usar la funci\u00f3n coincidir en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3>\u00bfC\u00f3mo funciona la funci\u00f3n de b\u00fasqueda en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d90bbde59\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d90bbde55\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Cualquier duda o pregunta, tan solo escr\u00edbenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p><p>Saludos,<\/p><p><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d8cdb3a34\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8cdb3a34\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d8cdb3a34\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d8cdb3a37\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17d8ce597b7\"] { width: 612px; --tve-border-width: 7px; border: 7px dashed rgb(239, 139, 4); --tve-applied-border: 7px dashed rgb(239,139,4); --tve-border-radius: 30px; border-radius: 30px; overflow: hidden; margin-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d8ce6ae3f\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce6ae3f\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d8ce6ae3f\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d8ce6ae42\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d8ce8ceeb\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8ce8ceeb\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d8ce8ceeb\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d8ce8ceee\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d8d043781\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8d043781\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d8d043781\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d8d043784\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; }[data-css=\"tve-u-17d8fed3a54\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-17d8fed3a54\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-17d8fed3a56\"] { max-width: 18.1%; }[data-css=\"tve-u-17d8fed3a57\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-17d8fed3a59\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fed3a5a\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-17d8fed3a5a\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-17d8fed3a5a\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17d8fed3a5c\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-17d8fed3a5d\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17d8fed3a5e\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-17d8fed3a5f\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-17d8fed3a5f\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d8fedc8cf\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d8fedc8cf\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d8fedc8cf\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d8fedc8d1\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d9059cd41\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9059cd41\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d9059cd41\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d9059cd45\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d9092f64b\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d9092f64b\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d9092f64b\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d9092f64e\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17d909fde85\"] { width: 204px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90a3f278\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90a3f278\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90a3f278\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90a3f27b\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90acc2c2\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90acc2c2\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90acc2c2\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90acc2c5\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90b0bb2a\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b0bb2a\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90b0bb2a\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90b0bb2d\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90b17379\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b17379\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90b17379\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90b1737c\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-17d90b20214\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; padding-top: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90b4b5a4\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90b4b5a4\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90b4b5a4\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90b4b5a8\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-17d90b9550b\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-17d90b9550d\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d90bbde55\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d90bbde55\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-17d90bbde55\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d90bbde59\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-17e60e63ea8\"] { font-size: 50px !important; }}@media (max-width: 767px){[data-css=\"tve-u-17d8fed3a5f\"] { margin-top: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[7656],"tags":[318,7510,7508,292,7509,7507,7512,7511],"class_list":["post-47365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-excel","tag-aplica-excel-contable","tag-aplicar-buscarx","tag-buscarx","tag-excel-y-contabilidad","tag-formula-buscarx","tag-funcion-buscarx","tag-sintaxis-buscarx","tag-utilizar-buscarx","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=47365"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/47408"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=47365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=47365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=47365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}