Aprenda as Funções Índice e Corresp no Excel - Ninja do Excel

Treinamento de Excel - ÍNDICE & CORRESP

Nesta aula, você vai aprender como utilizar a junção de 2 funções INCRÍVEIS:
Funções ÍNDICE + CORRESP

Quer continuar o treinamento e aprender de forma completa?
Clique aqui para ver as próximas aulas.

Curso de Excel Completo
Do Básico ao Avançado [com Bônus!]

Entenda como o curso Funciona:

Se você está precisando dar um upgrade no Excel, do básico ao avançado, conheça este curso de Excel completo que já ajudou milhares de pessoas no Brasil!

7 Cursos em 1 - Neste curso de Excel completo, você terá acesso à 5 cursos de Excel e 2 cursos bônus!
- Excel Fundamentos;
- Excel para iniciantes;
- Excel Avançado;
- Gráficos Avançados no Excel;
- Curso de Dashboards no Excel;
- BÔNUS: Curso de Word e PowerPoint.
Curso 100% online - Você não precisa se deslocar para fazer o curso. Acesse quando e onde quiser;
Fórum Exclusivo dos alunos - Se tiver qualquer dúvida durante o curso, você terá o suporte à dúvidas pelo fórum;
Faça o Download das planilhas - Você poderá baixar todas as planilhas do curso para treinar e usar de modelo para seus projetos;
1 ano de acesso! - Está sem tempo para fazero curso agora? Sem problemas! Dentro desse período, você pode acessar quando e quantas vezes quiser;
Certificado de conclusão de curso - Receba o certificado de conclusão de curso realizado para aprensentar na sua empresa!

QUERO FAZER ESTE CURSO!

Atendimento

Ficou alguma dúvida? Entre em contato com nosso atendimento online
(funcionamento em horário comercial)

Ninja do Excel - 2018 - Todos os Direitos reservados

This is the bottom slider area. You can edit this text and also insert any element here. This is a good place if you want to put an opt-in form or a scarcity countdown.

.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection{background:#1fac61;}.epc-ovr[class*=epc-s] #footer ::selection,.epc-ovr[class*=epc-s] #sidebar-promo ::selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::selection,.epc-ovr[class*=epc-s] .capture-wrap ::selection{background:#1fac61;}.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a,.epc-ovr .wp-calendar>caption,.epc-ovr input[type="submit"],.epc-ovr #header #nav input.search-submit[type="submit"],.epc-ovr #header .not-found input.search-submit[type="submit"],.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .uberaviso,.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sc.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .epico_author a[class*=button],.epc-ovr[class*="epc-"] input[type="submit"],.epc-ovr[class*="epc-"] .fw.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .not-found input.search-submit[type="submit"]{background:#1fac61;}.epc-ovr .pagination .page-numbers.current{background:#1fac61 !important;}.epc-ovr #footer .widget_tag_cloud a:hover,.epc-ovr .loop-meta,.epc-ovr #menu-primary-items .sub-menu li a:hover,.epc-ovr .epc-button-border-primary,.epc-ovr #footer .search-field:hover,.epc-ovr #footer .search-field:focus,.epc-ovr .author-profile,.epc-ovr.page-template-landing{border-left:5px solid #1fac61 !important;}.epc-ovr #credits,.epc-ovr[class*="epc-"] .sidebar .epico_pop,.epc-ovr[class*="epc-"] .sidebar .epico_pop > div,.epc-ovr[class*="epc-"] #footer .epico_social a:hover,.epc-ovr .comment-reply-link{border-color:#1fac61 !important;}.epc-ovr .epc-button-border-primary,.epc-ovr #footer .epico_social a:hover,.epc-ovr #sidebar-top li:hover::before,.epc-ovr #menu-primary .sub-menu li a:hover::before,.epc-ovr #footer li:hover::before,.epc-ovr #menu-primary li.menu-item-has-children a:hover::before,.epc-ovr #menu-secondary li a:hover::before,.epc-ovr #search-toggle:hover::after,.epc-ovr .search-close .search-text,.epc-ovr #search-toggle::before,.epc-ovr #search-toggle:hover .search-text,.epc-ovr .search-text:hover,.epc-ovr #zen:hover i,.epc-ovr #zen.zen-active i,.epc-ovr #zen.zen-active:hover i,.epc-ovr.zen #footer a{color:rgba(31,172,97,.8) !important;}.epc-ovr .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr .sidebar section[class*="epico_pages"] h3[class*="title"]::before{color:rgba(31,172,97,.8);}.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon{fill:#1fac61;}@media only screen and (max-width:680px){.epc-ovr #menu-primary>ul>li a:hover::before,.epc-ovr #menu-primary li a:hover::before,.epc-ovr #nav-toggle:hover .nav-text,.epc-ovr .nav-active #nav-toggle .nav-text{color:rgba(31,172,97,.8) !important;}.epc-ovr #menu-primary-items>li a:hover{border-left:5px solid rgba(31,172,97,.8) !important;}.epc-ovr .nav-active #nav-toggle span::before,.epc-ovr .nav-active #nav-toggle span::after,.epc-ovr #nav-toggle:hover .screen-reader-text,.epc-ovr #nav-toggle:hover .screen-reader-text::after,.epc-ovr #nav-toggle:hover .screen-reader-text::before{background:#1fac61 !important;}}@media only screen and (min-width:680px){.epc-ovr #header .menu-items > li > a{color:#1fac61;}}[class*="epc-"] #menu-secondary li a.menu-item:hover::before,.epc-ovr #page .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr #page .sidebar section[class*="epico_pages"] h3[class*="title"]::before,.epc-ovr #page a:not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link):not(.wp-block-social-link-anchor):not(.menu-item):not(.credit-link):not(.page-numbers),.epc-ovr.plural .format-default .entry-author,.epc-ovr #breadcrumbs a,.epc-ovr #branding a,.epc-ovr #header .menu-items > li > a:hover,.epc-ovr #footer .widget_tag_cloud a:hover::before,.epc-ovr #zen.zen-active:hover i,.epc-ovr.page-template-landing #footer a,.epc-ovr .uf-wrap .uf a:not(.uf-submit){color:#1fac61 !important;}.epc-ovr #page #main-container .pagination a.page-numbers,.epc-ovr[class*="epc-"].plural .format-default .entry-author,.epc-ovr[class*=epc-s] #page #main-container .epico_author a[class*=button]{color:#fff !important;}.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection,.epc-ovr #footer ::selection,.epc-ovr #sidebar-promo ::selection,.epc-ovr section[class*="pop-id"] ::selection,.epc-ovr .capture-wrap ::selection,.epc-ovr .epico_social a,.epc-ovr[class*=epc-s] .epico_author a[class*=button]{color:#fff;}.epc-ovr.epc-1 .uf_epicoepico_pop a,.epc-ovr.epc-2 .uf_epicoepico_pop a,.epc-ovr.epc-3 .uf_epicoepico_pop a{color:#aebbc2;}.epc-ovr #page a:not(.epico-pop_link):not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link):not(.epico-pop-link):hover,.epc-ovr .comment-reply-link,.epc-ovr.page-template-landing #footer a:hover,.epc-ovr #breadcrumbs a:hover{color:#344146;}.epc-ovr .comment-reply-link:hover{border-color:#344146 !important;}.epc-ovr input[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:hover,.epc-ovr .not-found input.search-submit[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:active,.epc-ovr .not-found input.search-submit[type="submit"]:active,.epc-ovr[class*=epc-s].zen #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr .pagination .page-numbers.current:active,.epc-ovr .pagination .page-numbers.current:hover{background:rgba(31,172,97,.6) !important;}.epc-ovr[class*=epc-s] .fw.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .sb.capture-wrap .uf-submit:hover,.epc-ovr .sc.capture-wrap .uf-submit:hover,.epc-ovr #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .epico_author a[class*=button]:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a:hover{background:rgba(31,172,97,.6);}.epc-ovr #page .content a.elementor-button,.epc-ovr #main-container .content a.elementor-button:hover{color:#fff;}.wordpress[class*="epc-"] #sidebar-subsidiary{background-color:#f4f4f4;color:rgba(0,0,0,.5);border-bottom:0px;}[class*="epc-"] #sidebar-subsidiary .epico_social a{background:rgba(0,0,0,.2);box-shadow:0 0 0 10px #f4f4f4;}[class*="epc-"] #sidebar-subsidiary .epico_social a:hover{box-shadow:0 0 0 10px rgba(0,0,0,.2);}.page-template-tpl-helper-pb[class*="epc-"],.page-template-tpl-helper-pb-alt[class*="epc-"],.page-template-tpl-helper-min-pb[class*="epc-"],.page-template-landing[class*="epc-"]{background-color:#fff !important;}.page-template-landing[class*="epc-"] #page,.page-template-tpl-helper-min-pb[class*="epc-"] #page{border-top:none !important;}[class*="epc-s"].plural .loop-meta{background:#42b267;}[class*="epc-s"].plural .loop-meta h1,[class*="epc-s"].plural .loop-meta p,[class*="epc-s"].plural #page .loop-meta li::before{color:rgba(255,255,255,.9);background:#42b267;}[class*="epc-s"].plural #page .loop-meta a{color:rgba(255,255,255,.6) !important;}.epc-syst,.epc-syst label,.epc-syst textarea,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]),.epc-syst select[multiple=multiple],.epc-syst.epc-button,.epc-syst input[type="submit"],.epc-syst a.uf-button,button.uf-button,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #comments .comment-reply-link,.epc-syst #comments .comment-reply-login,.epc-syst .epico_author a[class*=button],.epc-syst.wordpress div.uberaviso a[class*="button"],.epc-syst.wordpress .mejs-controls a:focus>.mejs-offscreen,.epc-syst .format-quote p:first-child::before,.epc-syst .format-quote p:first-child::after,.epc-syst .epico-related-posts h4.related-post-title,.epc-syst .placeholder,.epc-syst .editor-tag,.epc-syst .uf-title-inner,.epc-syst .wp-block-calendar table{font-family:ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla;}.epc-syst li.fa,.epc-syst li.fa::before,.epc-syst .fa,.epc-syst textarea.fa,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]).fa,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #search-wrap input.fa[type="search"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #respond #submit,.epc-syst .capture-wrap form input[class*="uf-"]{font-family:FontAwesome,ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla !important;}@media screen and (max-width:420px){.social-likes__counter{display:none;}.sticky-active .social-total-shares{right:0;}.sticky-active #social-bar-sticky #social-close{right:5px;}}body{font-family:"Open Sans",sans-serif;font-size:16px;color:#333;}body a{color:#428bca;}body a:hover,body a:focus{color:#2a6496;}body{min-height:auto;background-color:#fff;height:auto;background-image:none !important;background-repeat:repeat;background-position:left top;background-attachment:scroll;padding-top:0px;}body.nitro-lazy{background-image:none !important;}body.custom-background{background-color:#f4f4f4;}#ib2_el_Tox34A4Q-submit:hover,#ib2_el_Tox34A4Q-submit:active{color:#fff !important;text-shadow:1px 1px 0 #4a4a4a !important;background-color:#831c1a !important;border-color:#670000 !important;background-image:linear-gradient(center bottom,#831c1a 0%,#a63f3d) !important;background-image:-moz-linear-gradient(center bottom,#831c1a 0%,#a63f3d) !important;}#ib2_el_OGDrBqHR > .el-content > a.ib2-button:hover,#ib2_el_OGDrBqHR > .el-content > a.ib2-button:active{color:#fff !important;text-shadow:1px 1px 0 #4a4a4a !important;background-color:#ee4f10 !important;border-color:#d23300 !important;background-image:linear-gradient(center bottom,#ee4f10 0%,#ff7233) !important;background-image:-moz-linear-gradient(center bottom,#ee4f10 0%,#ff7233) !important;}#ib2_el_AEGhboQA > .el-content > a.ib2-button:hover,#ib2_el_AEGhboQA > .el-content > a.ib2-button:active{color:#fff !important;text-shadow:1px 1px 0 #4a4a4a !important;background-color:#246a25 !important;border-color:#084e09 !important;background-image:none !important;}#ib2_el_AEGhboQA > .el-content > a.ib2-button:hover.nitro-lazy,#ib2_el_AEGhboQA > .el-content > a.ib2-button:active.nitro-lazy{background-image:none !important;}