{"id":8566,"date":"2026-07-13T15:32:42","date_gmt":"2026-07-13T15:32:42","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=8566"},"modified":"2026-09-26T15:18:20","modified_gmt":"2026-09-26T15:18:20","slug":"excel-funcao-indireto-varios-para-um-selecao-de-municipios-indireto-para-uf","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/excel-funcao-indireto-varios-para-um-selecao-de-municipios-indireto-para-uf\/","title":{"rendered":"Excel | Fun\u00e7\u00e3o Indireto V\u00e1rios para um Sele\u00e7\u00e3o de Municipios indireto para UF"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8566\" class=\"elementor elementor-8566\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98ab632 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"98ab632\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2adf1be elementor-widget elementor-widget-heading\" data-id=\"2adf1be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">- EXCEL \u2022 DICAS PR\u00c1TICAS -<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7f66c1 elementor-widget elementor-widget-heading\" data-id=\"a7f66c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Como Criar uma Sele\u00e7\u00e3o de Munic\u00edpios Dependente da UF no Excel <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3b1c509 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3b1c509\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-e430cac e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"e430cac\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1f400aa elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"1f400aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;skin&quot;:&quot;classic&quot;}\" data-widget_type=\"search-form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<search role=\"search\">\n\t\t\t<form class=\"elementor-search-form\" action=\"https:\/\/fpw.com.br\/m\" method=\"get\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-search-form__container\">\n\t\t\t\t\t<label class=\"elementor-screen-only\" for=\"elementor-search-form-1f400aa\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-1f400aa\" placeholder=\"Search...\" class=\"elementor-search-form__input\" type=\"search\" name=\"s\" value=\"\">\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<button class=\"elementor-search-form__submit\" type=\"submit\" aria-label=\"Search\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"e-font-icon-svg-container\"><svg class=\"fa fa-search e-font-icon-svg e-fas-search\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M505 442.7L405.3 343c-4.5-4.5-10.6-7-17-7H372c27.6-35.3 44-79.7 44-128C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c48.3 0 92.7-16.4 128-44v16.3c0 6.4 2.5 12.5 7 17l99.7 99.7c9.4 9.4 24.6 9.4 33.9 0l28.3-28.3c9.4-9.4 9.4-24.6.1-34zM208 336c-70.7 0-128-57.2-128-128 0-70.7 57.2-128 128-128 70.7 0 128 57.2 128 128 0 70.7-57.2 128-128 128z\"><\/path><\/svg><\/div>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/form>\n\t\t<\/search>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fbbe7 elementor-widget elementor-widget-text-editor\" data-id=\"b6fbbe7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"7tzxst\" data-start=\"0\" data-end=\"93\">Utilizando a Fun\u00e7\u00e3o INDIRETO<\/h1><p data-start=\"95\" data-end=\"475\">Criar listas suspensas inteligentes no Excel \u00e9 uma excelente maneira de tornar suas planilhas mais organizadas, intuitivas e livres de erros de preenchimento. Um dos recursos mais \u00fateis para isso \u00e9 a combina\u00e7\u00e3o da <strong data-start=\"309\" data-end=\"331\">Valida\u00e7\u00e3o de Dados<\/strong> com a fun\u00e7\u00e3o <strong data-start=\"345\" data-end=\"357\">INDIRETO<\/strong>, permitindo que a lista de munic\u00edpios seja atualizada automaticamente conforme a Unidade Federativa (UF) selecionada.<\/p><p data-start=\"477\" data-end=\"628\">Neste artigo, voc\u00ea aprender\u00e1 como criar uma lista suspensa dependente, onde a escolha da UF determina quais munic\u00edpios ser\u00e3o exibidos na segunda lista.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-223f332 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"223f332\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-283f710 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"283f710\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3bf8c69 wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"3bf8c69\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dados\"]  data-filter=\".category-dados\">Dados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dashboard\"]  data-filter=\".category-dashboard\">Dashboard<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:116,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-10045 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/painel-financeiro.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/painel-financeiro.png\" alt=\"Dashboard Financeiro Completo\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\">Planilhas | Dashboard Financeiro Completo<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-10004 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/indicadores-de-rh-1.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/indicadores-de-rh-1.png\" alt=\"Indicadores de RH 2.6\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\">Planilhas | Indicadores de RH 2.6<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9992 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw category-tecnologia tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-lg-nuvem tag-o-que-significa-fpw tag-porque-o-fpw-trocou-de-nome tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.jpg\" alt=\"Transforme seu RH com agentes de IA, dados e Tecnologia\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\">FPw | Transforme seu RH com agentes de IA, dados e Tecnologia<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a4e5f7 elementor-widget elementor-widget-text-editor\" data-id=\"2a4e5f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"qrs23z\" data-start=\"635\" data-end=\"663\">O que \u00e9 a fun\u00e7\u00e3o INDIRETO?<\/h1><p data-start=\"665\" data-end=\"847\">A fun\u00e7\u00e3o <strong data-start=\"674\" data-end=\"686\">INDIRETO<\/strong> retorna uma refer\u00eancia especificada por um texto. Em outras palavras, ela permite transformar o conte\u00fado de uma c\u00e9lula em uma refer\u00eancia v\u00e1lida dentro do Excel.<\/p><p data-start=\"849\" data-end=\"871\">Sua sintaxe \u00e9 simples:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=INDIRETO(ref_texto; [a1])<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"914\" data-end=\"919\">Onde:<\/p><ul data-start=\"921\" data-end=\"1049\"><li data-section-id=\"sznwrd\" data-start=\"921\" data-end=\"985\"><strong data-start=\"923\" data-end=\"936\">ref_texto<\/strong>: \u00e9 o texto que representa a refer\u00eancia desejada.<\/li><li data-section-id=\"1ch0n6u\" data-start=\"986\" data-end=\"1049\"><strong data-start=\"988\" data-end=\"994\">a1<\/strong>: argumento opcional que define o estilo da refer\u00eancia.<\/li><\/ul><p data-start=\"1051\" data-end=\"1181\">Embora seja bastante utilizada em f\u00f3rmulas, a fun\u00e7\u00e3o INDIRETO tamb\u00e9m \u00e9 extremamente poderosa quando aplicada \u00e0 Valida\u00e7\u00e3o de Dados.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86403a5 elementor-widget elementor-widget-video\" data-id=\"86403a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=U3_nTxfVyII&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-621913e elementor-widget elementor-widget-text-editor\" data-id=\"621913e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"evjnat\" data-start=\"1188\" data-end=\"1212\">O objetivo da planilha<\/h1><p data-start=\"1214\" data-end=\"1366\">Imagine um cadastro de clientes onde o usu\u00e1rio precisa selecionar primeiro o estado (UF) e, em seguida, escolher um munic\u00edpio pertencente \u00e0quele estado.<\/p><p data-start=\"1368\" data-end=\"1511\">Sem uma lista dependente, todos os munic\u00edpios do Brasil apareceriam em uma \u00fanica lista, dificultando a sele\u00e7\u00e3o e aumentando as chances de erro.<\/p><p data-start=\"1513\" data-end=\"1597\">Com a fun\u00e7\u00e3o INDIRETO, a segunda lista exibir\u00e1 apenas os munic\u00edpios da UF escolhida.<\/p><p data-start=\"1599\" data-end=\"1607\">Exemplo:<\/p><p data-start=\"1609\" data-end=\"1627\"><strong data-start=\"1609\" data-end=\"1627\">UF selecionada<\/strong><\/p><p data-start=\"1629\" data-end=\"1638\">S\u00e3o Paulo<\/p><p data-start=\"1640\" data-end=\"1663\"><strong data-start=\"1640\" data-end=\"1663\">Lista de Munic\u00edpios<\/strong><\/p><ul data-start=\"1665\" data-end=\"1734\"><li data-section-id=\"l5fc76\" data-start=\"1665\" data-end=\"1675\">Campinas<\/li><li data-section-id=\"69lv6k\" data-start=\"1676\" data-end=\"1684\">Santos<\/li><li data-section-id=\"dwo4fz\" data-start=\"1685\" data-end=\"1701\">Ribeir\u00e3o Preto<\/li><li data-section-id=\"qrgj60\" data-start=\"1702\" data-end=\"1712\">Sorocaba<\/li><li data-section-id=\"4vtogj\" data-start=\"1713\" data-end=\"1734\">S\u00e3o Jos\u00e9 dos Campos<\/li><\/ul><p data-start=\"1736\" data-end=\"1821\">Se o usu\u00e1rio alterar a UF para Minas Gerais, a lista ser\u00e1 atualizada automaticamente.<\/p><hr data-start=\"1823\" data-end=\"1826\" \/><h1 data-section-id=\"tpcbit\" data-start=\"1828\" data-end=\"1851\">Estruturando os dados<\/h1><p data-start=\"1853\" data-end=\"1914\">Primeiro, organize suas informa\u00e7\u00f5es em uma planilha de apoio.<\/p><p data-start=\"1916\" data-end=\"1924\">Exemplo:<\/p><p data-start=\"1926\" data-end=\"1939\"><strong data-start=\"1926\" data-end=\"1939\">S\u00e3o_Paulo<\/strong><\/p><ul data-start=\"1941\" data-end=\"2000\"><li data-section-id=\"1ted7f4\" data-start=\"1941\" data-end=\"1952\">S\u00e3o Paulo<\/li><li data-section-id=\"l5fc76\" data-start=\"1953\" data-end=\"1963\">Campinas<\/li><li data-section-id=\"69lv6k\" data-start=\"1964\" data-end=\"1972\">Santos<\/li><li data-section-id=\"qrgj60\" data-start=\"1973\" data-end=\"1983\">Sorocaba<\/li><li data-section-id=\"dwo4fz\" data-start=\"1984\" data-end=\"2000\">Ribeir\u00e3o Preto<\/li><\/ul><p data-start=\"2002\" data-end=\"2018\"><strong data-start=\"2002\" data-end=\"2018\">Minas_Gerais<\/strong><\/p><ul data-start=\"2020\" data-end=\"2085\"><li data-section-id=\"nrm1i2\" data-start=\"2020\" data-end=\"2036\">Belo Horizonte<\/li><li data-section-id=\"1mrlijo\" data-start=\"2037\" data-end=\"2049\">Uberl\u00e2ndia<\/li><li data-section-id=\"1km9qr4\" data-start=\"2050\" data-end=\"2060\">Contagem<\/li><li data-section-id=\"s5hfpb\" data-start=\"2061\" data-end=\"2075\">Juiz de Fora<\/li><li data-section-id=\"1fcoj3e\" data-start=\"2076\" data-end=\"2085\">Uberaba<\/li><\/ul><p data-start=\"2087\" data-end=\"2097\"><strong data-start=\"2087\" data-end=\"2097\">Paran\u00e1<\/strong><\/p><ul data-start=\"2099\" data-end=\"2157\"><li data-section-id=\"fv0jwb\" data-start=\"2099\" data-end=\"2109\">Curitiba<\/li><li data-section-id=\"3gdw5\" data-start=\"2110\" data-end=\"2120\">Londrina<\/li><li data-section-id=\"x9spnb\" data-start=\"2121\" data-end=\"2130\">Maring\u00e1<\/li><li data-section-id=\"z4ldc4\" data-start=\"2131\" data-end=\"2141\">Cascavel<\/li><li data-section-id=\"3xdl88\" data-start=\"2142\" data-end=\"2157\">Foz do Igua\u00e7u<\/li><\/ul><p data-start=\"2159\" data-end=\"2203\">Cada coluna conter\u00e1 os munic\u00edpios de uma UF.<\/p><div class=\"TyagGW_tableContainer\">\u00a0<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cf92037 elementor-widget elementor-widget-heading\" data-id=\"cf92037\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Gostaria de aprimorar seu conhecimento em Excel,  aproveite nossos Cursos.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-502fce1 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"502fce1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-58dd0f9 e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"58dd0f9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1279f5c elementor-widget elementor-widget-image\" data-id=\"1279f5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/255edafd-e626-44de-832d-1be9942a5711\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo.png\" class=\"attachment-large size-large wp-image-9225\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a835ef elementor-widget elementor-widget-image\" data-id=\"8a835ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/6c607ccd-4032-41cf-a684-24e4155a6e2c\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png\" class=\"attachment-large size-large wp-image-9224\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-703e5b3 elementor-widget elementor-widget-image\" data-id=\"703e5b3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/c606ba66-754d-4046-abba-14865ca84bea\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa.png\" class=\"attachment-large size-large wp-image-9226\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-69c9ed1 elementor-widget elementor-widget-image\" data-id=\"69c9ed1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/3e5e88be-0c1f-4584-9e87-e79faadf4e16\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png\" class=\"attachment-large size-large wp-image-8381\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8dfb2cf elementor-widget elementor-widget-image\" data-id=\"8dfb2cf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/93c20c84-4cf9-4b01-bde9-346688b1d1fb\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png\" class=\"attachment-large size-large wp-image-9223\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ec50df elementor-widget elementor-widget-image\" data-id=\"7ec50df\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/d64a7982-1d4d-4e14-94cb-36dc13f393c3\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png\" class=\"attachment-large size-large wp-image-9227\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be147cd elementor-widget elementor-widget-text-editor\" data-id=\"be147cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1b71it1\" data-start=\"2210\" data-end=\"2242\">Criando os Intervalos Nomeados<\/h1><p data-start=\"2244\" data-end=\"2275\">Esse \u00e9 o passo mais importante.<\/p><p data-start=\"2277\" data-end=\"2344\">Selecione os munic\u00edpios de cada estado e crie um <strong data-start=\"2326\" data-end=\"2343\">Nome Definido<\/strong>.<\/p><p data-start=\"2346\" data-end=\"2358\">Por exemplo:<\/p><ul data-start=\"2360\" data-end=\"2412\"><li data-section-id=\"1bdqlu7\" data-start=\"2360\" data-end=\"2371\">S\u00e3o_Paulo<\/li><li data-section-id=\"pmnk90\" data-start=\"2372\" data-end=\"2386\">Minas_Gerais<\/li><li data-section-id=\"36h091\" data-start=\"2387\" data-end=\"2395\">Paran\u00e1<\/li><li data-section-id=\"11sc9t5\" data-start=\"2396\" data-end=\"2412\">Rio_de_Janeiro<\/li><\/ul><p data-start=\"2414\" data-end=\"2464\">Esses nomes ser\u00e3o utilizados pela fun\u00e7\u00e3o INDIRETO.<\/p><p data-start=\"2466\" data-end=\"2570\"><strong data-start=\"2466\" data-end=\"2481\">Importante:<\/strong> nomes definidos n\u00e3o podem conter espa\u00e7os. Utilize o caractere &#8220;_&#8221; para separar palavras.<\/p><hr data-start=\"2572\" data-end=\"2575\" \/><h1 data-section-id=\"1ekta5v\" data-start=\"2577\" data-end=\"2608\">Criando a primeira lista (UF)<\/h1><p data-start=\"2610\" data-end=\"2660\">Agora selecione a c\u00e9lula onde ser\u00e1 escolhida a UF.<\/p><p data-start=\"2662\" data-end=\"2676\">Depois acesse:<\/p><p data-start=\"2678\" data-end=\"2716\"><strong data-start=\"2678\" data-end=\"2716\">Dados \u2192 Valida\u00e7\u00e3o de Dados \u2192 Lista<\/strong><\/p><p data-start=\"2718\" data-end=\"2769\">Como origem, utilize a lista contendo todas as UFs.<\/p><p data-start=\"2771\" data-end=\"2779\">Exemplo:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=Lista_UF<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"2805\" data-end=\"2842\">ou selecione diretamente o intervalo.<\/p><hr data-start=\"2844\" data-end=\"2847\" \/><h1 data-section-id=\"unusbm\" data-start=\"2849\" data-end=\"2887\">Criando a segunda lista (Munic\u00edpios)<\/h1><p data-start=\"2889\" data-end=\"2937\">Agora selecione a c\u00e9lula destinada ao munic\u00edpio.<\/p><p data-start=\"2939\" data-end=\"2956\">Novamente acesse:<\/p><p data-start=\"2958\" data-end=\"2996\"><strong data-start=\"2958\" data-end=\"2996\">Dados \u2192 Valida\u00e7\u00e3o de Dados \u2192 Lista<\/strong><\/p><p data-start=\"2998\" data-end=\"3027\">Na caixa <strong data-start=\"3007\" data-end=\"3017\">Origem<\/strong>, utilize:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=INDIRETO(SUBSTITUIR(A2;\" \";\"_\"))<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"3077\" data-end=\"3091\">Nesse exemplo:<\/p><ul data-start=\"3093\" data-end=\"3243\"><li data-section-id=\"1i51f5x\" data-start=\"3093\" data-end=\"3126\"><strong data-start=\"3095\" data-end=\"3101\">A2<\/strong> cont\u00e9m a UF selecionada.<\/li><li data-section-id=\"1jfj9kf\" data-start=\"3127\" data-end=\"3169\"><strong data-start=\"3129\" data-end=\"3143\">SUBSTITUIR<\/strong> troca os espa\u00e7os por &#8220;_&#8221;.<\/li><li data-section-id=\"15krz95\" data-start=\"3170\" data-end=\"3243\"><strong data-start=\"3172\" data-end=\"3184\">INDIRETO<\/strong> transforma esse texto no nome do intervalo correspondente.<\/li><\/ul><p data-start=\"3245\" data-end=\"3362\">Assim, ao selecionar uma UF, o Excel localizar\u00e1 automaticamente o intervalo nomeado com os munic\u00edpios daquele estado.<\/p><hr data-start=\"3364\" data-end=\"3367\" \/><h1 data-section-id=\"1ujauwi\" data-start=\"3369\" data-end=\"3386\">Exemplo pr\u00e1tico<\/h1><p data-start=\"3388\" data-end=\"3400\">Suponha que:<\/p><p data-start=\"3402\" data-end=\"3423\">A2 = &#8220;Rio de Janeiro&#8221;<\/p><p data-start=\"3425\" data-end=\"3435\">A f\u00f3rmula:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=INDIRETO(SUBSTITUIR(A2;\" \";\"_\"))<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"3485\" data-end=\"3498\">transformar\u00e1:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\">\u00a0<\/div><div class=\"relative\"><div class=\"pe-11 pt-3\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>Rio de Janeiro<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"3524\" data-end=\"3526\">em<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\">\u00a0<\/div><div class=\"relative\"><div class=\"pe-11 pt-3\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>Rio_de_Janeiro<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"3552\" data-end=\"3666\">Como existe um intervalo nomeado com esse nome, o Excel exibir\u00e1 apenas os munic\u00edpios cadastrados para esse estado.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c1da7 elementor-widget elementor-widget-text-editor\" data-id=\"e8c1da7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1k4zt1h\" data-start=\"3673\" data-end=\"3697\">Vantagens desse m\u00e9todo<\/h1><p data-start=\"3699\" data-end=\"3775\">Utilizar a fun\u00e7\u00e3o INDIRETO em listas dependentes oferece diversas vantagens:<\/p><ul data-start=\"3777\" data-end=\"3997\"><li data-section-id=\"d6a9cc\" data-start=\"3777\" data-end=\"3804\">Evita erros de digita\u00e7\u00e3o.<\/li><li data-section-id=\"qfp7wv\" data-start=\"3805\" data-end=\"3847\">Facilita o preenchimento de formul\u00e1rios.<\/li><li data-section-id=\"vao5ir\" data-start=\"3848\" data-end=\"3882\">Organiza grandes bases de dados.<\/li><li data-section-id=\"10yc8me\" data-start=\"3883\" data-end=\"3918\">Melhora a experi\u00eancia do usu\u00e1rio.<\/li><li data-section-id=\"dbofvz\" data-start=\"3919\" data-end=\"3956\">Torna a planilha mais profissional.<\/li><li data-section-id=\"1ypq4f2\" data-start=\"3957\" data-end=\"3997\">Automatiza processos sem utilizar VBA.<\/li><\/ul><p data-start=\"3999\" data-end=\"4096\">\u00c9 uma solu\u00e7\u00e3o simples e eficiente para formul\u00e1rios de cadastro e sistemas desenvolvidos no Excel.<\/p><hr data-start=\"4098\" data-end=\"4101\" \/><h1 data-section-id=\"1kn9123\" data-start=\"4103\" data-end=\"4124\">Aplica\u00e7\u00f5es pr\u00e1ticas<\/h1><p data-start=\"4126\" data-end=\"4186\">Essa t\u00e9cnica pode ser utilizada em diversas situa\u00e7\u00f5es, como:<\/p><ul data-start=\"4188\" data-end=\"4380\"><li data-section-id=\"1yg640l\" data-start=\"4188\" data-end=\"4211\">Cadastro de clientes.<\/li><li data-section-id=\"12afhr7\" data-start=\"4212\" data-end=\"4239\">Cadastro de fornecedores.<\/li><li data-section-id=\"id64zy\" data-start=\"4240\" data-end=\"4261\">Controle de vendas.<\/li><li data-section-id=\"1bsnkq0\" data-start=\"4262\" data-end=\"4287\">Formul\u00e1rios comerciais.<\/li><li data-section-id=\"1v20qz0\" data-start=\"4288\" data-end=\"4310\">Sistemas de estoque.<\/li><li data-section-id=\"1gvzbw2\" data-start=\"4311\" data-end=\"4334\">Controle patrimonial.<\/li><li data-section-id=\"18qb1sp\" data-start=\"4335\" data-end=\"4354\">Recursos Humanos.<\/li><li data-section-id=\"1a8jjlv\" data-start=\"4355\" data-end=\"4380\">Dashboards interativos.<\/li><\/ul><p data-start=\"4382\" data-end=\"4508\">Sempre que uma escolha depender de outra, a combina\u00e7\u00e3o entre Valida\u00e7\u00e3o de Dados e INDIRETO pode ser uma excelente alternativa.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6dcca85 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"6dcca85\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-5b6e136 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"5b6e136\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cbac0ae elementor-widget elementor-widget-text-editor\" data-id=\"cbac0ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Tem uma d\u00favida de Excel?<\/span><\/h2><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados.<\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado?<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c0c2b4 elementor-widget elementor-widget-text-editor\" data-id=\"1c0c2b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"8rgxxc\" data-start=\"4515\" data-end=\"4534\">Erros mais comuns<\/h1><p data-start=\"4536\" data-end=\"4606\">Alguns problemas costumam impedir o funcionamento da lista dependente:<\/p><p data-start=\"4608\" data-end=\"4678\">\u274c Intervalos nomeados com nomes diferentes dos valores da lista de UF.<\/p><p data-start=\"4680\" data-end=\"4716\">\u274c Espa\u00e7os n\u00e3o tratados corretamente.<\/p><p data-start=\"4718\" data-end=\"4759\">\u274c Erros de digita\u00e7\u00e3o nos nomes definidos.<\/p><p data-start=\"4761\" data-end=\"4808\">\u274c Refer\u00eancias incorretas na Valida\u00e7\u00e3o de Dados.<\/p><p data-start=\"4810\" data-end=\"4855\">\u274c Exclus\u00e3o acidental dos intervalos nomeados.<\/p><p data-start=\"4857\" data-end=\"4920\">Verifique esses pontos caso a lista n\u00e3o funcione como esperado.<\/p><hr data-start=\"4922\" data-end=\"4925\" \/><h1 data-section-id=\"17wl73q\" data-start=\"4927\" data-end=\"4962\">Dica para planilhas profissionais<\/h1><p data-start=\"4964\" data-end=\"5225\">Se sua base de dados cresce com frequ\u00eancia, considere transformar as listas em <strong data-start=\"5043\" data-end=\"5063\">Tabelas do Excel<\/strong> e gerenciar os intervalos nomeados de forma organizada. Isso facilita a manuten\u00e7\u00e3o da planilha e reduz o risco de erros ao adicionar novos munic\u00edpios ou estados.<\/p><hr data-start=\"5227\" data-end=\"5230\" \/><h1 data-section-id=\"1g4xr35\" data-start=\"5232\" data-end=\"5243\">Conclus\u00e3o<\/h1><p data-start=\"5245\" data-end=\"5573\">A fun\u00e7\u00e3o <strong data-start=\"5254\" data-end=\"5266\">INDIRETO<\/strong>, combinada com a <strong data-start=\"5284\" data-end=\"5306\">Valida\u00e7\u00e3o de Dados<\/strong>, \u00e9 uma das maneiras mais eficientes de criar listas suspensas dependentes no Excel. Com ela, \u00e9 poss\u00edvel construir formul\u00e1rios inteligentes que exibem apenas as op\u00e7\u00f5es relevantes para cada sele\u00e7\u00e3o, tornando suas planilhas mais organizadas, intuitivas e profissionais.<\/p><p data-start=\"5575\" data-end=\"5787\" data-is-last-node=\"\" data-is-only-node=\"\">Dominar essa t\u00e9cnica \u00e9 um grande diferencial para quem desenvolve sistemas, cadastros e dashboards no Excel, pois melhora a usabilidade, reduz erros de preenchimento e transmite muito mais qualidade aos projetos.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-1024x576.jpg\" class=\"attachment-large size-large wp-image-8567\" alt=\"Como Criar uma Sele\u00e7\u00e3o de Munic\u00edpios Dependente da UF no Excel Utilizando a Fun\u00e7\u00e3o INDIRETO\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-1024x576.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-300x169.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-768x432.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-150x85.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto-600x338.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f6809c1 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"f6809c1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3b722 wpr-comment-reply-separate wpr-comment-reply-align-right elementor-widget elementor-widget-wpr-post-comments\" data-id=\"8d3b722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-post-comments.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-comments-wrap\" id=\"comments\">\t<div id=\"respond\" class=\"comment-respond\">\n\t\t<h3 id=\"wpr-reply-title\" class=\"wpr-comment-reply-title\">Leave a Reply <small><a rel=\"nofollow\" id=\"cancel-comment-reply-link\" href=\"\/m\/wp-json\/wp\/v2\/posts\/8566#respond\" style=\"display:none;\">Cancelar resposta<\/a><\/small><\/h3><form action=\"https:\/\/fpw.com.br\/m\/wp-comments-post.php\" method=\"post\" id=\"wpr-comment-form\" class=\"wpr-comment-form wpr-cf-style-5\"><p class=\"comment-notes\"><span id=\"email-notes\">O seu endere\u00e7o de e-mail n\u00e3o ser\u00e1 publicado.<\/span> <span class=\"required-field-message\">Campos obrigat\u00f3rios s\u00e3o marcados com <span class=\"required\">*<\/span><\/span><\/p><div class=\"wpr-comment-form-text\"><label>Message<span>*<\/span><\/label><textarea autocomplete=\"new-password\"   name=\"ea4449d22c\"  placeholder=\"\" cols=\"45\" rows=\"8\" maxlength=\"65525\"><\/textarea><textarea id=\"comment\" aria-label=\"hp-comment\" aria-hidden=\"true\" name=\"comment\" autocomplete=\"new-password\" style=\"padding:0 !important;clip:rect(1px, 1px, 1px, 1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;\" tabindex=\"-1\"><\/textarea><\/div><p class=\"comment-form-author\"><input id=\"author\" class=\"comment-form__field\" name=\"author\" type=\"text\" placeholder=\"Nome *\" value=\"\" size=\"30\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-email\"><input id=\"email\" class=\"comment-form__field\" name=\"email\" type=\"text\" placeholder=\"E-mail *\" value=\"\" size=\"30\" aria-describedby=\"email-notes\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-url\"><input id=\"url\" class=\"comment-form__field\" name=\"url\" type=\"text\" placeholder=\"Site\" value=\"\" size=\"30\" \/><\/p>\n<p class=\"form-submit\"><input name=\"submit\" type=\"submit\" id=\"wpr-submit-comment\" class=\"wpr-submit-comment\" value=\"Submit\" \/> <input type='hidden' name='comment_post_ID' value='9992' id='comment_post_ID' \/>\n<input type='hidden' name='comment_parent' id='comment_parent' value='0' \/>\n<\/p><\/form>\t<\/div><!-- #respond -->\n\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>&#8211; EXCEL \u2022 DICAS PR\u00c1TICAS &#8211; Como Criar uma Sele\u00e7\u00e3o de Munic\u00edpios Dependente da UF no Excel Utilizando a Fun\u00e7\u00e3o INDIRETO Criar listas suspensas inteligentes no Excel \u00e9 uma excelente maneira de tornar suas planilhas mais organizadas, intuitivas e livres de erros de preenchimento. Um dos recursos mais \u00fateis para isso \u00e9 a combina\u00e7\u00e3o da Valida\u00e7\u00e3o de Dados com a fun\u00e7\u00e3o INDIRETO, permitindo que a lista de munic\u00edpios seja atualizada automaticamente conforme a Unidade Federativa (UF) selecionada. Neste artigo, voc\u00ea aprender\u00e1 como criar uma lista suspensa dependente, onde a escolha da UF determina quais munic\u00edpios ser\u00e3o exibidos na segunda lista. All Posts Blog Certificados Dados Dashboard Diversos Excel FPw Membros Not\u00c3\u00adcias Planilhas Produtos SQL Tecnologia WordPress FPw | Onde encontrar cursos de FPw e LG Nuvem? Leia mais Dados | Sua empresa provavelmente n\u00e3o sofre de falta de dados. Leia mais Dashboard | 3 erros que fazem um Dashboard Financeiro parecer profissional \u2014 mas entregar decis\u00f5es ruins Leia mais O que \u00e9 a fun\u00e7\u00e3o INDIRETO? A fun\u00e7\u00e3o INDIRETO retorna uma refer\u00eancia especificada por um texto. Em outras palavras, ela permite transformar o conte\u00fado de uma c\u00e9lula em uma refer\u00eancia v\u00e1lida dentro do Excel. Sua sintaxe \u00e9 simples: \u00a0 =INDIRETO(ref_texto; [a1]) \u00a0 Onde: ref_texto: \u00e9 o texto que representa a refer\u00eancia desejada. a1: argumento opcional que define o estilo da refer\u00eancia. Embora seja bastante utilizada em f\u00f3rmulas, a fun\u00e7\u00e3o INDIRETO tamb\u00e9m \u00e9 extremamente poderosa quando aplicada \u00e0 Valida\u00e7\u00e3o de Dados. https:\/\/www.youtube.com\/watch?v=U3_nTxfVyII O objetivo da planilha Imagine um cadastro de clientes onde o usu\u00e1rio precisa selecionar primeiro o estado (UF) e, em seguida, escolher um munic\u00edpio pertencente \u00e0quele estado. Sem uma lista dependente, todos os munic\u00edpios do Brasil apareceriam em uma \u00fanica lista, dificultando a sele\u00e7\u00e3o e aumentando as chances de erro. Com a fun\u00e7\u00e3o INDIRETO, a segunda lista exibir\u00e1 apenas os munic\u00edpios da UF escolhida. Exemplo: UF selecionada S\u00e3o Paulo Lista de Munic\u00edpios Campinas Santos Ribeir\u00e3o Preto Sorocaba S\u00e3o Jos\u00e9 dos Campos Se o usu\u00e1rio alterar a UF para Minas Gerais, a lista ser\u00e1 atualizada automaticamente. Estruturando os dados Primeiro, organize suas informa\u00e7\u00f5es em uma planilha de apoio. Exemplo: S\u00e3o_Paulo S\u00e3o Paulo Campinas Santos Sorocaba Ribeir\u00e3o Preto Minas_Gerais Belo Horizonte Uberl\u00e2ndia Contagem Juiz de Fora Uberaba Paran\u00e1 Curitiba Londrina Maring\u00e1 Cascavel Foz do Igua\u00e7u Cada coluna conter\u00e1 os munic\u00edpios de uma UF. \u00a0 Gostaria de aprimorar seu conhecimento em Excel, aproveite nossos Cursos. Criando os Intervalos Nomeados Esse \u00e9 o passo mais importante. Selecione os munic\u00edpios de cada estado e crie um Nome Definido. Por exemplo: S\u00e3o_Paulo Minas_Gerais Paran\u00e1 Rio_de_Janeiro Esses nomes ser\u00e3o utilizados pela fun\u00e7\u00e3o INDIRETO. Importante: nomes definidos n\u00e3o podem conter espa\u00e7os. Utilize o caractere &#8220;_&#8221; para separar palavras. Criando a primeira lista (UF) Agora selecione a c\u00e9lula onde ser\u00e1 escolhida a UF. Depois acesse: Dados \u2192 Valida\u00e7\u00e3o de Dados \u2192 Lista Como origem, utilize a lista contendo todas as UFs. Exemplo: \u00a0 =Lista_UF \u00a0 ou selecione diretamente o intervalo. Criando a segunda lista (Munic\u00edpios) Agora selecione a c\u00e9lula destinada ao munic\u00edpio. Novamente acesse: Dados \u2192 Valida\u00e7\u00e3o de Dados \u2192 Lista Na caixa Origem, utilize: \u00a0 =INDIRETO(SUBSTITUIR(A2;&#8221; &#8220;;&#8221;_&#8221;)) \u00a0 Nesse exemplo: A2 cont\u00e9m a UF selecionada. SUBSTITUIR troca os espa\u00e7os por &#8220;_&#8221;. INDIRETO transforma esse texto no nome do intervalo correspondente. Assim, ao selecionar uma UF, o Excel localizar\u00e1 automaticamente o intervalo nomeado com os munic\u00edpios daquele estado. Exemplo pr\u00e1tico Suponha que: A2 = &#8220;Rio de Janeiro&#8221; A f\u00f3rmula: \u00a0 =INDIRETO(SUBSTITUIR(A2;&#8221; &#8220;;&#8221;_&#8221;)) \u00a0 transformar\u00e1: \u00a0 Rio de Janeiro \u00a0 em \u00a0 Rio_de_Janeiro \u00a0 Como existe um intervalo nomeado com esse nome, o Excel exibir\u00e1 apenas os munic\u00edpios cadastrados para esse estado. Vantagens desse m\u00e9todo Utilizar a fun\u00e7\u00e3o INDIRETO em listas dependentes oferece diversas vantagens: Evita erros de digita\u00e7\u00e3o. Facilita o preenchimento de formul\u00e1rios. Organiza grandes bases de dados. Melhora a experi\u00eancia do usu\u00e1rio. Torna a planilha mais profissional. Automatiza processos sem utilizar VBA. \u00c9 uma solu\u00e7\u00e3o simples e eficiente para formul\u00e1rios de cadastro e sistemas desenvolvidos no Excel. Aplica\u00e7\u00f5es pr\u00e1ticas Essa t\u00e9cnica pode ser utilizada em diversas situa\u00e7\u00f5es, como: Cadastro de clientes. Cadastro de fornecedores. Controle de vendas. Formul\u00e1rios comerciais. Sistemas de estoque. Controle patrimonial. Recursos Humanos. Dashboards interativos. Sempre que uma escolha depender de outra, a combina\u00e7\u00e3o entre Valida\u00e7\u00e3o de Dados e INDIRETO pode ser uma excelente alternativa. Tem uma d\u00favida de Excel? Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados. Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado? Erros mais comuns Alguns problemas costumam impedir o funcionamento da lista dependente: \u274c Intervalos nomeados com nomes diferentes dos valores da lista de UF. \u274c Espa\u00e7os n\u00e3o tratados corretamente. \u274c Erros de digita\u00e7\u00e3o nos nomes definidos. \u274c Refer\u00eancias incorretas na Valida\u00e7\u00e3o de Dados. \u274c Exclus\u00e3o acidental dos intervalos nomeados. Verifique esses pontos caso a lista n\u00e3o funcione como esperado. Dica para planilhas profissionais Se sua base de dados cresce com frequ\u00eancia, considere transformar as listas em Tabelas do Excel e gerenciar os intervalos nomeados de forma organizada. Isso facilita a manuten\u00e7\u00e3o da planilha e reduz o risco de erros ao adicionar novos munic\u00edpios ou estados. Conclus\u00e3o A fun\u00e7\u00e3o INDIRETO, combinada com a Valida\u00e7\u00e3o de Dados, \u00e9 uma das maneiras mais eficientes de criar listas suspensas dependentes no Excel. Com ela, \u00e9 poss\u00edvel construir formul\u00e1rios inteligentes que exibem apenas as op\u00e7\u00f5es relevantes para cada sele\u00e7\u00e3o, tornando suas planilhas mais organizadas, intuitivas e profissionais. Dominar essa t\u00e9cnica \u00e9 um grande diferencial para quem desenvolve sistemas, cadastros e dashboards no Excel, pois melhora a usabilidade, reduz erros de preenchimento e transmite muito mais qualidade aos projetos. 2 Comments Bulk Material Transfer25 de setembro de 2026 at 12:24 | Edit Everyone loves what you guys tend to be up too. Such clever work and reporting! Keep up the fantastic works guys I&#8217;ve included you guys to blogroll. Responder Silo Design25 de setembro de 2026 at 05:09 | Edit Hey there, I think your site might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening<\/p>\n","protected":false},"author":2000,"featured_media":8567,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[49,90,84,92,259,260,261,40,262,263,29,48,77,55,56,103,5,101,81,86,98,87,6,47,74,75,93],"class_list":["post-8566","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-aprenda-como-usar-no-excel-avancado","tag-aprenda-todas-as-possibilidades-de-formatacoes-no-excel","tag-como-desproteger-um-arquivo-do-excel-protegido-por-senha","tag-crie-um-sistema-de-sorteio-no-excel-de-forma-simples","tag-dashboard","tag-dashboard-financeiro","tag-dashboard-financeiro-pessoal","tag-dashboard-para-controle-financeiro","tag-dashboard-rh-controle-de-desligamentos","tag-dashboard-seguranca-do-trabalho","tag-excel","tag-formula-se-com-procv","tag-funcao-arrumar-com-alguns-truques","tag-funcoes-basicas-do-excel","tag-funcoes-basicas-operadores","tag-grafico-medidor-de-bateria","tag-menu-dados-completo","tag-montando-um-resumo-de-diversas-planilhas-com-somase","tag-planilha-de-controle-financeiro-tudo-o-que-voce-precisa-saber","tag-planilhas","tag-procv-junto-com-o-corresp","tag-protegendo-celulas","tag-saiba-tudo-da-parte-de-dados","tag-software-de-planilha-online-gratuito-excel-microsoft-365","tag-tudo-sobre-formatacao-de-celulas","tag-tudo-sobre-lista-suspensa-no-excel","tag-tudo-sobre-tabela-e-graficos-dinamicos"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/indireto.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=8566"}],"version-history":[{"count":3,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8566\/revisions"}],"predecessor-version":[{"id":9926,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8566\/revisions\/9926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/8567"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=8566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=8566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=8566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}