{"id":2572,"date":"2025-07-12T12:06:17","date_gmt":"2025-07-12T12:06:17","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2572"},"modified":"2025-07-13T15:14:42","modified_gmt":"2025-07-13T15:14:42","slug":"corrigir-excel-vlookup-nao-funcionando","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando","title":{"rendered":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>VLOOKUP<\/strong> (Pesquisa Vertical) \u00e9 uma excelente fun\u00e7\u00e3o que busca um valor exato na primeira coluna da tabela e retorna um valor correspondente de outra coluna na mesma linha. \u00c0s vezes, por\u00e9m, voc\u00ea pode se deparar com uma situa\u00e7\u00e3o em que essa <strong>fun\u00e7\u00e3o n\u00e3o funciona<\/strong>. Nesses casos, \u00e9 importante corrigir esse problema para uma experi\u00eancia de planilha fluida. Bem, este blog explora os motivos mais comuns pelos quais o VLOOKUP n\u00e3o est\u00e1 funcionando e como corrigi-lo rapidamente.<!--more--><\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<h2 style=\"text-align: left;\"><strong>Por que meu VLOOKUP n\u00e3o est\u00e1 funcionando?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Nesta se\u00e7\u00e3o, voc\u00ea encontrar\u00e1 a resposta para esta pergunta important\u00edssima: por que o VLOOKUP n\u00e3o est\u00e1 funcionando? Ent\u00e3o, confira os 7 motivos mais comuns pelos quais o <strong>VLOOKUP n\u00e3o funciona no Excel 2007\/2010\/2013\/2016\/2019.<\/strong><\/p>\n<p style=\"text-align: justify;\">Dar uma olhada&#8230;<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong><a href=\"#a1\">VLOOKUP n\u00e3o \u00e9 poss\u00edvel encontrar o valor<\/a><\/strong><\/li>\n<li><strong><a href=\"#a2\">A refer\u00eancia da tabela est\u00e1 bloqueada<\/a><\/strong><\/li>\n<li><strong><a href=\"#a3\">Inser\u00e7\u00e3o de Coluna<\/a><\/strong><\/li>\n<li><strong><a href=\"#a4\">Mesa de grandes dimens\u00f5es<\/a><\/strong><\/li>\n<li><strong><a href=\"#a5\">VLOOKUP n\u00e3o pode olhar para a esquerda<\/a><\/strong><\/li>\n<li><strong><a href=\"#a6\">N\u00e3o obtendo a correspond\u00eancia exata<\/a><\/strong><\/li>\n<li><strong><a href=\"#a7\">Tabela Excel tem valores duplicados<\/a><\/strong><\/li>\n<\/ul>\n<p><a name=\"a1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Raz\u00e3o 1 # VLOOKUP N\u00e3o \u00e9 poss\u00edvel encontrar o valor<\/strong><\/h3>\n<p style=\"text-align: justify;\">O usu\u00e1rio do Excel que est\u00e1 usando as\u00a0fun\u00e7\u00f5es\u00a0<strong>VLOOKUP, MATCH\u00a0<\/strong>ou\u00a0<strong>HLOOKUP de\u00a0<\/strong>vez em quando encontrou algum\u00a0<strong>erro\u00a0<\/strong>#\u00a0<strong>N \/ A\u00a0<\/strong>inesperado.<\/p>\n<p style=\"text-align: justify;\">Normalmente, esse erro \u00e9 encontrado quando algu\u00e9m tenta corresponder ao valor de pesquisa do Excel dentro da matriz.\u00a0\u00c9 um sinal claro de que sua fun\u00e7\u00e3o do Excel falhou ao buscar o valor de pesquisa da matriz de pesquisa.<\/p>\n<p style=\"text-align: justify;\">O que voc\u00ea far\u00e1 se perceber que o valor de correspond\u00eancia exata est\u00e1 na matriz de pesquisa, mas seu aplicativo do Excel n\u00e3o consegue encontrar esse valor?<\/p>\n<p style=\"text-align: justify;\">Suponha: se na planilha do Excel mostrada, a fun\u00e7\u00e3o de pesquisa \u00e9 aplicada.\u00a0Voc\u00ea deseja pesquisar o valor &#8220;1110004&#8221; da c\u00e9lula para obter uma correspond\u00eancia com o valor &#8220;1110004&#8221; presente na c\u00e9lula E6.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2574\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-1.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 1funcionando 1\" width=\"421\" height=\"187\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-1.png 421w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-1-300x133.png 300w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/p>\n<p style=\"text-align: justify;\">Nesse caso, se a fun\u00e7\u00e3o do Excel falhar em buscar a correspond\u00eancia ou apresentar o erro # N \/ A, erro.\u00a0A fun\u00e7\u00e3o VLOOKUP \u00e9 uma fun\u00e7\u00e3o de consulta e refer\u00eancia popular do Excel.\u00a0Ele mostrar\u00e1 uma mensagem de erro # N \/ A complicada e temida.\u00a0Isso pode acontecer porque o Excel n\u00e3o est\u00e1 considerando os dois valores exatamente iguais.<\/p>\n<p><a name=\"a2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Raz\u00e3o 2 # A refer\u00eancia da tabela est\u00e1 bloqueada<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se voc\u00ea estiver usando v\u00e1rios VLOOKUPs no Excel para capturar informa\u00e7\u00f5es diferentes sobre qualquer registro espec\u00edfico.\u00a0ou se voc\u00ea deseja copiar sua VLOOKUP para v\u00e1rias de suas c\u00e9lulas, ent\u00e3o voc\u00ea deve verificar sua tabela.<\/p>\n<p style=\"text-align: justify;\">A imagem mostrada abaixo mostra que a VLOOKUP inserida aqui est\u00e1 incorreta.\u00a0Os intervalos de c\u00e9lulas incorretos s\u00e3o referenciados para\u00a0<em>lookup_value\u00a0<\/em>e table array.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2575\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-2.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 funcionando 2\" width=\"640\" height=\"343\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-2.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-2-300x161.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p style=\"text-align: justify;\">A tabela que \u00e9 usada pela fun\u00e7\u00e3o VLOOKUP realmente procura e fornece informa\u00e7\u00f5es \u00e9 chamada de\u00a0<em>table_array\u00a0<\/em>.\u00a0Isso \u00e9 necess\u00e1rio para ser referenciado completamente a fim de copiar seu VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, clique nas refer\u00eancias que est\u00e3o dentro da f\u00f3rmula e depois pressione a tecla F4 do seu teclado para modificar a refer\u00eancia de\u00a0relativa para absoluta\u00a0.\u00a0Portanto,\u00a0insira a f\u00f3rmula\u00a0como =\u00a0VLOOKUP ($ H $ 3, $ B $ 3: $ F $ 11,4, FALSO)\u00a0.<\/p>\n<p style=\"text-align: justify;\">Neste exemplo, as\u00a0refer\u00eancias\u00a0<em>lookup_value\u00a0<\/em>e\u00a0<em>table_array\u00a0<\/em>feitas eram absolutas.\u00a0Basicamente, pode ser o\u00a0<em>table_array que precisa de bloqueio.<\/em><\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/abrir-excel-no-modo-de-seguranca\" target=\"_blank\" rel=\"noopener\">Por que o Excel em Modo Final n\u00e3o funciona? \u2013 Consiga solu\u00e7\u00f5es aqui!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"a3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Raz\u00e3o 3 # Inser\u00e7\u00e3o de coluna<\/strong><\/h3>\n<p style=\"text-align: justify;\">O n\u00famero do \u00edndice da coluna ou\u00a0<em>col_index_num\u00a0<\/em>\u00e9 usado pela fun\u00e7\u00e3o VLOOKUP para inserir informa\u00e7\u00f5es para retornar um registro.<\/p>\n<p style=\"text-align: justify;\">Porque isso \u00e9 inserido como um n\u00famero de \u00edndice e n\u00e3o \u00e9 dur\u00e1vel.\u00a0Se uma coluna for colocada na tabela, ent\u00e3o\u00a0<strong>vlookup n\u00e3o est\u00e1 funcionando,\u00a0<\/strong>pois isso impede que VLOOKUP funcione.\u00a0Aqui est\u00e1 a imagem mostrada abaixo para um cen\u00e1rio.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2576\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-3.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 funcionando 3\" width=\"640\" height=\"202\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-3.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-3-300x95.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\">Todo o conte\u00fado est\u00e1 na coluna 3, mas ap\u00f3s a inser\u00e7\u00e3o da nova coluna, ele se tornou a coluna 4.\u00a0Por\u00e9m, o VLOOKUP n\u00e3o foi atualizado automaticamente.<\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o 1<\/strong><\/p>\n<p style=\"text-align: justify;\">Uma solu\u00e7\u00e3o \u00e9 tentar salvar sua planilha para que qualquer outro usu\u00e1rio n\u00e3o possa inserir colunas.\u00a0Se o usu\u00e1rio solicitar, n\u00e3o \u00e9 uma solu\u00e7\u00e3o v\u00e1lida.<\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o 2<\/strong><\/p>\n<p style=\"text-align: justify;\">Outra op\u00e7\u00e3o \u00e9 inserir a\u00a0fun\u00e7\u00e3o\u00a0MATCH\u00a0no\u00a0argumento\u00a0<em>col_index_num\u00a0<\/em>de VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">A\u00a0fun\u00e7\u00e3o\u00a0MATCH\u00a0pode ser usada para pesquisar algo ou retornar o n\u00famero da coluna necess\u00e1ria.\u00a0Isso vai;\u00a0torna o\u00a0<em>col_index_num din\u00e2mico para que as\u00a0<\/em>colunas\u00a0<em>inseridas\u00a0<\/em>n\u00e3o afetem o VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">A f\u00f3rmula fornecida abaixo precisa ser inserida neste exemplo para evitar o problema mencionado acima.<\/p>\n<p><a name=\"a4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Raz\u00e3o 4 # Tabela superdimensionada<\/strong><\/h3>\n<p style=\"text-align: justify;\">Quando mais linhas s\u00e3o adicionadas \u00e0 tabela, o VLookup precisa ser atualizado.\u00a0A imagem abaixo mostra que o VLookup n\u00e3o verifica itens completos de frutas da mesa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2577\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-4.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 funcionando 4\" width=\"640\" height=\"275\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-4.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-4-300x129.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode considerar o intervalo de formata\u00e7\u00e3o como um nome de intervalo din\u00e2mico ou tabela (Excel 2007+).\u00a0Este processo garante que o VLookup examinar\u00e1 toda a sua tabela.<\/p>\n<p style=\"text-align: justify;\">Para formatar o intervalo como uma tabela, escolha o intervalo de c\u00e9lulas que deseja usar para\u00a0table_array.\u00a0Depois,\u00a0toque em\u00a0<strong>In\u00edcio\u00a0&gt;\u00a0Formatar<\/strong> como mesa\u00a0e escolha qualquer um dos estilos da se\u00e7\u00e3o da galeria.\u00a0Toque na\u00a0guia\u00a0Design\u00a0presente nas\u00a0<strong>Ferramentas de\u00a0Tabela\u00a0e, a seguir, altere\u00a0o\u00a0nome\u00a0da tabela\u00a0na caixa fornecida.<\/strong><\/p>\n<p style=\"text-align: justify;\">A VLOOKUP abaixo mostra uma tabela chamada\u00a0<em>FruitList\u00a0<\/em>sendo usada.\u00a0<em>\u00a0<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2578\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-5.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 funcionando 5\" width=\"640\" height=\"215\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-5.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-5-300x101.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><br \/>\n<a name=\"a5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Raz\u00e3o 5 # VLOOKUP n\u00e3o pode olhar para a esquerda<\/strong><\/h3>\n<p style=\"text-align: justify;\">A limita\u00e7\u00e3o da fun\u00e7\u00e3o VLOOKUP \u00e9 que ela n\u00e3o pode olhar para a esquerda.\u00a0Isso aparecer\u00e1 na coluna mais \u00e0 esquerda de uma tabela e retornar\u00e1 informa\u00e7\u00f5es da direita.<\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p style=\"text-align: justify;\">A solu\u00e7\u00e3o para corrigir o problema de VLOOKUP que n\u00e3o est\u00e1 funcionando \u00e9 n\u00e3o usar VLOOKUP.\u00a0Voc\u00ea pode usar a combina\u00e7\u00e3o das\u00a0fun\u00e7\u00f5es \u00cdNDICE e CORRESPOND\u00caNCIA do Excel como alternativa para VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">O exemplo abaixo \u00e9 para mostrar quais informa\u00e7\u00f5es s\u00e3o retornadas \u00e0 esquerda da coluna que voc\u00ea est\u00e1 procurando.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2580\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-7.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 funcionando 7\" width=\"640\" height=\"340\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-7.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-7-300x159.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><br \/>\n<a name=\"a6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Raz\u00e3o 6 # N\u00e3o obter a correspond\u00eancia exata<\/strong><\/h3>\n<p style=\"text-align: justify;\">No argumento final da fun\u00e7\u00e3o VLOOKUP, tamb\u00e9m conhecido como\u00a0<em>range_lookup\u00a0<\/em>, voc\u00ea pode pesquisar a correspond\u00eancia aproximada ou exata.<\/p>\n<p style=\"text-align: justify;\">Na maioria dos casos, os usu\u00e1rios procuram por determinado pedido de produto, funcion\u00e1rio ou cliente e, portanto, exigem uma correspond\u00eancia exata.\u00a0se voc\u00ea estiver procurando por qualquer valor exclusivo, digite FALSE para o\u00a0argumento\u00a0<em>range_lookup\u00a0<\/em>.<\/p>\n<p style=\"text-align: justify;\">Este \u00e9 opcional, mas se n\u00e3o for preenchido, o valor TRUE deve ser usado.\u00a0O valor TRUE depende de seus dados serem classificados para funcionar.<\/p>\n<p style=\"text-align: justify;\">A figura abaixo mostrada mostrar\u00e1 um VLOOKUP com o argumento range_lookup omitido e o valor incorreto sendo retornado.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3799\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/vlookup-not-working-7.png\" alt=\"VLookup n\u00e3o funcionar 7\" width=\"640\" height=\"343\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/vlookup-not-working-7.png 640w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/vlookup-not-working-7-300x161.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p style=\"text-align: justify;\">Se estiver procurando por algum valor exclusivo, insira o\u00a0valor\u00a0FALSE\u00a0para o argumento final.\u00a0A VLOOKUP deve ser inserida como\u00a0= VLOOKUP (H3, B3: F11,2, FALSO)\u00a0.<\/p>\n<p style=\"text-align: justify;\">Esta \u00e9 a primeira raz\u00e3o para o\u00a0<strong>VLookup n\u00e3o funcionar\u00a0<\/strong>no Excel.<\/p>\n<p><a name=\"a7\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Raz\u00e3o 7 # Tabela do Excel com valores duplicados<\/strong><\/h3>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o VLOOKUP do Excel \u00e9 limitada para retornar apenas um registro.\u00a0D\u00e1-1\u00a0<sup>st\u00a0<\/sup>registro que corresponde ao valor que voc\u00ea est\u00e1 procurando.<\/p>\n<p style=\"text-align: justify;\">Se a sua tabela do Excel estiver com algumas duplicatas, VLOOKUP n\u00e3o consegue realizar esta tarefa.<\/p>\n<p style=\"text-align: justify;\"><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p style=\"text-align: justify;\">Na lista exibida, alguns valores duplicados est\u00e3o presentes.\u00a0Nesse caso, VLOOKUP n\u00e3o \u00e9 a escolha certa a ser usada.\u00a0A Tabela Din\u00e2mica \u00e9 a op\u00e7\u00e3o perfeita para escolher o valor e listar o resultado.<\/p>\n<p style=\"text-align: justify;\">A tabela abaixo mostrada mostra uma lista de pedidos.\u00a0Suponha que voc\u00ea esteja disposto a devolver todo o pedido de qualquer fruta espec\u00edfica.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3798\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-8.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 1funcionando 8\" width=\"589\" height=\"349\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-8.png 589w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-8-300x178.png 300w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/p>\n<p style=\"text-align: justify;\">A Tabela Din\u00e2mica permite que voc\u00ea escolha o ID da fruta no filtro de relat\u00f3rio e a lista de todos os pedidos come\u00e7a a aparecer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3794\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-9.png\" alt=\"Excel VLOOKUP n\u00e3o est\u00e1 1funcionando 9\" width=\"605\" height=\"448\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-9.png 605w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/excel-vlookup-not-working-9-300x222.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p style=\"text-align: justify;\">Estas s\u00e3o as 7 melhores raz\u00f5es para o\u00a0<strong>erro VLOOKUP n\u00e3o funcionar\u00a0<\/strong>no Excel.\u00a0Felizmente, agora o\u00a0<strong>VLOOKUP Excel n\u00e3o vai funcionar\u00a0<\/strong>quest\u00e3o\u00a0\u00e9 fixa, mas se n\u00e3o, ent\u00e3o fazer uso da solu\u00e7\u00e3o autom\u00e1tica para corre\u00e7\u00e3o VLOOKUP n\u00e3o vai trabalhar erro no Excel.<strong>\u00a0<\/strong><\/p>\n<h2 style=\"text-align: left;\"><strong>Solu\u00e7\u00e3o autom\u00e1tica: ferramenta de reparo do MS Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">A solu\u00e7\u00e3o manual fornecida certamente corrigir\u00e1 seus problemas e erros de arquivo do Excel. mas se no caso de voc\u00ea ser pego em qualquer outra falha de corrup\u00e7\u00e3o ou problemas de arquivo danificado, use a\u00a0<strong><a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\">MS Excel reparo ferramenta<\/a>. <\/strong>\u00c9 o software mais adequado para restaurar arquivos corrompidos do Excel e tamb\u00e9m para recuperar dados de planilhas do Excel, como coment\u00e1rios de c\u00e9lulas, gr\u00e1ficos, propriedades da planilha e outras coisas. \u00c9 um programa projetado profissionalmente que\u00a0facilmente<a href=\"http:\/\/pt.repairmsexcel.com\/blog\/13-maneiras-de-reparar-corrupto-excel-arquivo\" target=\"_blank\" rel=\"noopener\"> <strong>repara\u00a0<\/strong><strong>arquivos .xls e .xlsx.<\/strong><\/a><\/p>\n<p style=\"text-align: justify;\"><center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<h3 style=\"text-align: left;\"><strong>Etapas para utilizar a ferramenta de reparo do MS Excel:<\/strong><\/h3>\n<p style=\"text-align: left;\">[pt-repair-<span class=\"markd3q42x9mj\" data-markjs=\"true\" data-ogac=\"\" data-ogab=\"\" data-ogsc=\"\" data-ogsb=\"\">guide<\/span>]\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/resolvido-como-corrigir-o-microsoft-excel-2016-autosave-nao-esta-funcionando\" target=\"_blank\" rel=\"noopener\">O salvamento autom\u00e1tico n\u00e3o funciona no Excel? 7 maneiras de consertar!<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Pr\u00e1ticas recomendadas para evitar problemas com VLOOKUP<\/strong><\/h2>\n<p>Siga estas medidas de precau\u00e7\u00e3o para evitar problemas no futuro.<\/p>\n<ol>\n<li>Use correspond\u00eancia exata, a menos que seja necess\u00e1rio.<\/li>\n<li>Sempre limpe seus dados antes de aplicar f\u00f3rmulas.<\/li>\n<li>Valide os n\u00fameros de \u00edndice das colunas regularmente.<\/li>\n<li>Teste suas f\u00f3rmulas com valores conhecidos.<\/li>\n<li>Bloqueie a matriz da sua tabela com sinais $.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Perguntas frequentes relacionadas:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Por que meu VLOOKUP mostra &#8220;NA&#8221; quando o valor existe?<\/strong><\/h4>\n<p>Se a sua coluna de pesquisa contiver valores de texto, mas a sua consulta de pesquisa estiver formatada como valores num\u00e9ricos, VLOOKUP mostrar\u00e1 o erro #N\/D.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como habilitar VLOOKUP no Excel?<\/strong><\/h4>\n<p>Para habilitar VLOOKUP no Excel, siga os passos abaixo:<\/p>\n<ul>\n<li style=\"text-align: left;\">Clique na(s) c\u00e9lula(s) onde voc\u00ea deseja que o Excel retorne os dados que voc\u00ea est\u00e1 procurando.<\/li>\n<li style=\"text-align: left;\">Em seguida, digite =VLOOKUP(valor da pesquisa, matriz da tabela, n\u00famero de \u00edndice da coluna, intervalo da pesquisa).<\/li>\n<li style=\"text-align: left;\">Por fim, pressione <strong>Enter<\/strong>.<\/li>\n<\/ul>\n<h4 style=\"text-align: left;\"><strong>Qual \u00e9 a alternativa para VLOOKUP?<\/strong><\/h4>\n<p>XLOOKUP e \u00cdNDICE\/CORRESP s\u00e3o as duas alternativas recomendadas para VLOOKUP.<\/p>\n<h4 style=\"text-align: left;\"><strong>Por que meu VLOOKUP n\u00e3o est\u00e1 funcionando com #Valor?<\/strong><\/h4>\n<p>VLOOKUP n\u00e3o est\u00e1 funcionando com #valor devido a um erro de digita\u00e7\u00e3o no argumento n\u00fam_\u00edndice_coluna ou \u00e0 especifica\u00e7\u00e3o acidental de um n\u00famero menor que 1 como valor de \u00edndice.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como fazer VLOOKUP funcionar?<\/strong><\/h4>\n<p>Para fazer a fun\u00e7\u00e3o VLOOKUP funcionar novamente, siga os passos abaixo.<\/p>\n<ul>\n<li>Selecione uma c\u00e9lula (H4)<\/li>\n<li>Em seguida, digite =VLOOKUP.<\/li>\n<li>Em seguida, clique duas vezes no comando VLOOKUP.<\/li>\n<li>Selecione a(s) c\u00e9lula(s) onde o valor da pesquisa ser\u00e1 inserido (H3)<\/li>\n<li>Digite ( , )<\/li>\n<li>Marque o intervalo da tabela (A2:E21)<\/li>\n<li>Digite ( , )<\/li>\n<li>Digite o n\u00famero da coluna, contado da esquerda para a direita (2).<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Veredito Final<\/strong><\/h2>\n<p style=\"text-align: justify;\">O <strong>problema de VLOOKUP n\u00e3o funcionar no Microsoft Excel<\/strong> \u00e9 frustrante, mas solucion\u00e1vel. No entanto, identificando a causa exata e aplicando as corre\u00e7\u00f5es espec\u00edficas especificadas acima, voc\u00ea pode corrigir os erros rapidamente. Limpe seus dados, use correspond\u00eancia exata e considere alternativas modernas para obter melhores resultados.<\/p>\n<p style=\"text-align: justify;\">Deixe suas planilhas funcionarem de forma mais inteligente, e n\u00e3o com mais esfor\u00e7o. Espero que voc\u00ea tenha gostado de ler este post.<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>VLOOKUP (Pesquisa Vertical) \u00e9 uma excelente fun\u00e7\u00e3o que busca um valor exato na primeira coluna da tabela e retorna um &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#more-2572\" aria-label=\"Read more about Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":2583,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[1046,1278],"class_list":["post-2572","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-excel-vlookup-nao-funciona","tag-vlookup-nao-funciona-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!<\/title>\n<meta name=\"description\" content=\"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\" \/>\n<meta property=\"og:description\" content=\"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-12T12:06:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-13T15:14:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#article\",\"isPartOf\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\",\"datePublished\":\"2025-07-12T12:06:17+00:00\",\"dateModified\":\"2025-07-13T15:14:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\"},\"wordCount\":1846,\"publisher\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png\",\"keywords\":[\"Excel VLOOKUP n\u00e3o funciona\",\"vlookup n\u00e3o funciona no Excel\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\",\"name\":\"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\",\"isPartOf\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png\",\"datePublished\":\"2025-07-12T12:06:17+00:00\",\"dateModified\":\"2025-07-13T15:14:42+00:00\",\"description\":\"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!\",\"breadcrumb\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png\",\"contentUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png\",\"width\":960,\"height\":540,\"caption\":\"5 raz\u00f5es pelas quais Excel VLOOKUP n\u00e3o funcionando\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pt.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur\"],\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!","description":"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!","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:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando","og_locale":"en_US","og_type":"article","og_title":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!","og_description":"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2025-07-12T12:06:17+00:00","article_modified_time":"2025-07-13T15:14:42+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!","datePublished":"2025-07-12T12:06:17+00:00","dateModified":"2025-07-13T15:14:42+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando"},"wordCount":1846,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png","keywords":["Excel VLOOKUP n\u00e3o funciona","vlookup n\u00e3o funciona no Excel"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando","url":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando","name":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png","datePublished":"2025-07-12T12:06:17+00:00","dateModified":"2025-07-13T15:14:42+00:00","description":"O VLOOKUP n\u00e3o est\u00e1 funcionando no Excel? Descubra dicas de especialistas para solucionar o problema rapidamente. Volte ao trabalho sem complica\u00e7\u00f5es!","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/02\/EXCEL-VLOOKUP-NOT-WORKING-pt.png","width":960,"height":540,"caption":"5 raz\u00f5es pelas quais Excel VLOOKUP n\u00e3o funcionando"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-excel-vlookup-nao-funcionando#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Por que VLOOKUP n\u00e3o funciona no Excel? Encontre solu\u00e7\u00f5es aqui!"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2572"}],"version-history":[{"count":12,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2572\/revisions"}],"predecessor-version":[{"id":5299,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2572\/revisions\/5299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2583"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}