{"id":18051,"date":"2022-02-27T09:00:00","date_gmt":"2022-02-27T14:00:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=18051"},"modified":"2026-02-04T22:04:53","modified_gmt":"2026-02-05T03:04:53","slug":"llamado-de-datos","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/","title":{"rendered":"Llamado de datos"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-llamado-de-datos-funcion-buscarv\">LLAMADO DE DATOS &#8211; Funci\u00f3n BuscarV<\/h2>\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=\"Nuevo Curso de Excel - Cap\u00edtulo 7, Llamado de Datos \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/5ikDKz9Efqs?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<h2 class=\"wp-block-heading\" id=\"h-descripcion\" style=\"margin-top:var(--wp--preset--spacing--40);margin-bottom:var(--wp--preset--spacing--40)\">DESCRIPCI\u00d3N<\/h2>\n\n\n\n<p>En este cap\u00edtulo veremos el famoso llamado o b\u00fasqueda de datos usando la funci\u00f3n BuscarV, es un tema muy interesante, ya que con esta funci\u00f3n podremos automatizar muchas cosas, para algunos puede ser un tema algo avanzado, pero no se preocupen lo iremos viendo de a poco para que entienda cada uno de los pasos y los errores frecuentes que pueden encontrar junto a la manera de resolverlos.<\/p>\n\n\n\n<p>Esta funci\u00f3n tienen muchas aplicaciones, yo les mostrar\u00e9 como utilizarla en una factura de venta, pero ustedes pueden aplicarla para sus trabajos e incluso de manera personal, no olviden ver el v\u00eddeo hasta el final y realizar la tarea que les he dejado, tambi\u00e9n recuerden reaccionar el v\u00eddeo si les ha gustado, comentar cualquier duda y compartirlo si conocen a alguien que le pueda interesar.<\/p>\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\">\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-7253e5\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-89f001 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/04\/capitulo_7.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/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-tarea-resuelta-0\">TAREA RESUELTA<\/h2>\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=\"Nuevo Curso de Excel - Cap\u00edtulo 7, Tarea \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ozSh-t-28g0?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<h2 class=\"wp-block-heading\" id=\"h-descripcion-0\" style=\"margin-top:var(--wp--preset--spacing--40);margin-bottom:var(--wp--preset--spacing--40)\">DESCRIPCI\u00d3N<\/h2>\n\n\n\n<p>En este v\u00eddeo encontrar\u00e1n la manera de resolver la tarea del cap\u00edtulo 7 del nuevo curso de Excel, espero que hayan intentado resolver la tarea por su propia cuenta y que si ya no lo lograron vean este v\u00eddeo, aprovechar\u00e9 para explicar algunas cosas que adicionales de esta funci\u00f3n con estos 3 ejercicios.<\/p>\n\n\n\n<p>Espero que lo vean hasta el final y de esta manera le puedan sacar el mayor provecho a este v\u00eddeo, recuerden que se encuentra oculto y solo lo podr\u00e1n ver los suscriptores del canal, si quedan con alguna duda no duden dejarla en los comentarios.<\/p>\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-0\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\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-9ff248\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-ec480e ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/05\/capitulo_7_Tarea.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En este cap\u00edtulo veremos el famoso llamado o b\u00fasqueda de datos usando la funci\u00f3n BuscarV, es un tema muy interesante, ya que con esta funci\u00f3n podremos automatizar muchas cosas, para algunos puede ser un tema algo avanzado, pero no se preocupen lo iremos viendo de a poco para que entienda cada uno de los pasos y los errores frecuentes que pueden encontrar junto a la manera de resolverlos.<\/p>\n","protected":false},"author":4,"featured_media":27277,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1714],"tags":[1805,116,730,562,186,225,232,550,277,539,327,1769,405,570,744,486],"class_list":["post-18051","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-curso-basico-intermedio","tag-1805","tag-base-de-datos","tag-buscarv","tag-curso","tag-datos","tag-excel","tag-facil","tag-factura","tag-gratis","tag-gratuito","tag-llamado-de-datos","tag-nuevo-curso","tag-programacion","tag-recomendado","tag-tarea","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Llamado de datos - Dostin Hurtado<\/title>\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\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Llamado de datos\" \/>\n<meta property=\"og:description\" content=\"En este cap\u00edtulo veremos el famoso llamado o b\u00fasqueda de datos usando la funci\u00f3n BuscarV, es un tema muy interesante, ya que con esta funci\u00f3n podremos automatizar muchas cosas, para algunos puede ser un tema algo avanzado, pero no se preocupen lo iremos viendo de a poco para que entienda cada uno de los pasos y los errores frecuentes que pueden encontrar junto a la manera de resolverlos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-27T14:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-05T03:04:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Llamado de datos\",\"datePublished\":\"2022-02-27T14:00:00+00:00\",\"dateModified\":\"2026-02-05T03:04:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\"},\"wordCount\":349,\"commentCount\":9,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif\",\"keywords\":[\"2022\",\"Base de Datos\",\"BuscarV\",\"Curso\",\"Datos\",\"Excel\",\"Facil\",\"Factura\",\"Gratis\",\"Gratuito\",\"Llamado de Datos\",\"nuevo curso\",\"programaci\u00f3n\",\"recomendado\",\"tarea\",\"Tutorial\"],\"articleSection\":[\"Nuevo Curso de Excel B\u00e1sico e Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\",\"name\":\"Llamado de datos - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif\",\"datePublished\":\"2022-02-27T14:00:00+00:00\",\"dateModified\":\"2026-02-05T03:04:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif\",\"width\":500,\"height\":375,\"caption\":\"Llamado de datos en Excel curso b\u00e1sico e intermedio\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Llamado de datos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Llamado de datos - Dostin Hurtado","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\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/","og_locale":"es_ES","og_type":"article","og_title":"Llamado de datos","og_description":"En este cap\u00edtulo veremos el famoso llamado o b\u00fasqueda de datos usando la funci\u00f3n BuscarV, es un tema muy interesante, ya que con esta funci\u00f3n podremos automatizar muchas cosas, para algunos puede ser un tema algo avanzado, pero no se preocupen lo iremos viendo de a poco para que entienda cada uno de los pasos y los errores frecuentes que pueden encontrar junto a la manera de resolverlos.","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/","og_site_name":"Dostin Hurtado","article_published_time":"2022-02-27T14:00:00+00:00","article_modified_time":"2026-02-05T03:04:53+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Llamado de datos","datePublished":"2022-02-27T14:00:00+00:00","dateModified":"2026-02-05T03:04:53+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/"},"wordCount":349,"commentCount":9,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif","keywords":["2022","Base de Datos","BuscarV","Curso","Datos","Excel","Facil","Factura","Gratis","Gratuito","Llamado de Datos","nuevo curso","programaci\u00f3n","recomendado","tarea","Tutorial"],"articleSection":["Nuevo Curso de Excel B\u00e1sico e Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/","name":"Llamado de datos - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif","datePublished":"2022-02-27T14:00:00+00:00","dateModified":"2026-02-05T03:04:53+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif","width":500,"height":375,"caption":"Llamado de datos en Excel curso b\u00e1sico e intermedio"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/llamado-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Llamado de datos"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-7-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":9,"uagb_excerpt":"En este cap\u00edtulo veremos el famoso llamado o b\u00fasqueda de datos usando la funci\u00f3n BuscarV, es un tema muy interesante, ya que con esta funci\u00f3n podremos automatizar muchas cosas, para algunos puede ser un tema algo avanzado, pero no se preocupen lo iremos viendo de a poco para que entienda cada uno de los pasos&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18051","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=18051"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18051\/revisions"}],"predecessor-version":[{"id":27466,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18051\/revisions\/27466"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27277"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=18051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=18051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=18051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}