{"id":1825,"date":"2025-08-01T14:48:15","date_gmt":"2025-08-01T17:48:15","guid":{"rendered":"https:\/\/inpo.com.br\/?p=1825"},"modified":"2025-08-01T14:48:15","modified_gmt":"2025-08-01T17:48:15","slug":"funcoes-do-excel-como-usar-xlookup-e-outras-juntas","status":"publish","type":"post","link":"https:\/\/inpo.com.br\/en\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/","title":{"rendered":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!"},"content":{"rendered":"<p data-start=\"545\" data-end=\"865\">Saber usar uma f\u00f3rmula j\u00e1 ajuda, mas <strong data-start=\"592\" data-end=\"621\">entender como combinar fun\u00e7\u00f5es do Excel <\/strong>\u00e9 o que realmente transforma seu n\u00edvel de produtividade.<\/p>\n<p data-start=\"545\" data-end=\"865\">Neste artigo, nosso analista Thales Wruck mostra como unir as fun\u00e7\u00f5es <strong data-start=\"733\" data-end=\"763\">XLOOKUP, LEFT, RIGHT e LEN<\/strong> para resolver problemas comuns, como <strong data-start=\"802\" data-end=\"864\">localizar, extrair e analisar dados com rapidez e precis\u00e3o<\/strong>.<\/p>\n<h2 data-start=\"867\" data-end=\"903\">Quando usar essas fun\u00e7\u00f5es do Excel juntas?<\/h2>\n<p>Imagine o seguinte cen\u00e1rio: voc\u00ea recebe uma planilha com c\u00f3digos como <strong>BR-SPOT12345-XYZ<\/strong> e precisa:<\/p>\n<ul data-start=\"1006\" data-end=\"1211\">\n<li data-start=\"1006\" data-end=\"1062\">\n<p data-start=\"1008\" data-end=\"1062\"><strong data-start=\"1008\" data-end=\"1039\">Localizar o nome do cliente<\/strong> com base nesse c\u00f3digo;<\/p>\n<\/li>\n<li data-start=\"1063\" data-end=\"1118\">\n<p data-start=\"1065\" data-end=\"1118\"><strong data-start=\"1065\" data-end=\"1093\">Extrair partes do c\u00f3digo<\/strong> para verificar a filial;<\/p>\n<\/li>\n<li data-start=\"1119\" data-end=\"1211\">\n<p data-start=\"1121\" data-end=\"1211\"><strong data-start=\"1121\" data-end=\"1154\">Validar o comprimento do dado<\/strong>, garantindo que todos os registros sigam o mesmo padr\u00e3o.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1213\" data-end=\"1320\">Parece complicado? Na pr\u00e1tica, n\u00e3o \u00e9. Ali\u00e1s, com as fun\u00e7\u00f5es certas, essa tarefa pode levar apenas segundos.<\/p>\n<h2 data-start=\"1527\" data-end=\"1561\">1. Procurando dados com XLOOKUP<\/h2>\n<p data-start=\"1563\" data-end=\"1752\">A fun\u00e7\u00e3o XLOOKUP (ou PROCX, em portugu\u00eas)\u00a0permite buscar uma informa\u00e7\u00e3o em uma tabela com base em outro valor. Diferente do antigo PROCV, ela \u00e9 mais flex\u00edvel, moderna e f\u00e1cil de usar.<\/p>\n<h3 data-start=\"1754\" data-end=\"1774\">Exemplo pr\u00e1tico:<\/h3>\n<p data-start=\"1776\" data-end=\"1912\">Voc\u00ea tem uma tabela com instala\u00e7\u00f5es e seus respectivos volumes movimentados. Quer saber o volume associado \u00e0 instala\u00e7\u00e3o CD6.<\/p>\n<p data-start=\"1914\" data-end=\"1952\">Com o XLOOKUP, a f\u00f3rmula fica assim:<\/p>\n<p data-start=\"1914\" data-end=\"1952\">=XLOOKUP(&#8220;CD6&#8221;, A2:A10, B2:B10)<\/p>\n<ul data-start=\"2000\" data-end=\"2174\">\n<li data-start=\"2000\" data-end=\"2059\">\n<p data-start=\"2002\" data-end=\"2059\">O primeiro argumento \u00e9 o que voc\u00ea quer encontrar (CD6);<\/p>\n<\/li>\n<li data-start=\"2060\" data-end=\"2112\">\n<p data-start=\"2062\" data-end=\"2112\">O segundo \u00e9 a coluna onde vai procurar (A2:A10);<\/p>\n<\/li>\n<li data-start=\"2113\" data-end=\"2174\">\n<p data-start=\"2115\" data-end=\"2174\">O terceiro \u00e9 de onde deseja extrair o resultado (B2:B10).<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"2205\" data-end=\"2338\">Se voc\u00ea mudar o valor buscado para \u201cLoja 2\u201d, por exemplo, o Excel vai retornar outro resultado, desde que a tabela contenha esse dado.<\/p>\n<p data-start=\"2205\" data-end=\"2338\">Isso torna a an\u00e1lise muito mais r\u00e1pida em tabelas grandes, evitando filtros ou buscas manuais linha por linha.<\/p>\n<h2 data-start=\"2459\" data-end=\"2508\">2. Extraindo partes de textos com as fun\u00e7\u00f5es do Excel RIGHT e LEFT<\/h2>\n<p data-start=\"2510\" data-end=\"2663\">Agora, imagine que voc\u00ea tem c\u00f3digos de identifica\u00e7\u00e3o, como ID1234-UF, e deseja extrair apenas a sigla do estado, que aparece no final do texto.<\/p>\n<p data-start=\"2665\" data-end=\"2787\">Para isso, usamos a fun\u00e7\u00e3o RIGHT, que l\u00ea da direita para a esquerda, pegando a quantidade de caracteres que voc\u00ea quiser.<\/p>\n<h3 data-start=\"2789\" data-end=\"2801\">Por exemplo:<\/h3>\n<p>=RIGHT(A2, 2)<\/p>\n<p data-start=\"2831\" data-end=\"2886\">Se o conte\u00fado for ID1234-RJ, o Excel retornar\u00e1: RJ.<\/p>\n<p data-start=\"2888\" data-end=\"2970\">Se quiser o in\u00edcio do c\u00f3digo (por exemplo, a parte ID1234), use a fun\u00e7\u00e3o LEFT:<\/p>\n<p data-start=\"2888\" data-end=\"2970\">=LEFT(A2, 6)<\/p>\n<p data-start=\"2888\" data-end=\"2970\">Essa combina\u00e7\u00e3o \u00e9 extremamente \u00fatil quando voc\u00ea lida com c\u00f3digos padronizados e precisa separ\u00e1-los em partes distintas.<\/p>\n<h2 data-start=\"3148\" data-end=\"3211\">3. Combinando LEFT com LEN para extrair apenas o que importa<\/h2>\n<p data-start=\"3213\" data-end=\"3348\">Mas, e se voc\u00ea quiser extrair tudo que vem antes de um sufixo fixo, como -UF, sem contar quantos caracteres tem a parte \u00fatil?<\/p>\n<p data-start=\"3350\" data-end=\"3479\">Nesse caso, o ideal \u00e9 usar a fun\u00e7\u00e3o LEN, que conta a quantidade total de caracteres na c\u00e9lula, e subtrair os que voc\u00ea n\u00e3o quer. Por exemplo:<\/p>\n<p data-start=\"3495\" data-end=\"3544\">Imagine o conte\u00fado da c\u00e9lula A2 seja: ID1234-RJ<\/p>\n<ul data-start=\"3546\" data-end=\"3766\">\n<li data-start=\"3546\" data-end=\"3603\">\n<p data-start=\"3548\" data-end=\"3603\">A parte que voc\u00ea <strong data-start=\"3565\" data-end=\"3577\">n\u00e3o quer<\/strong> (-RJ)\u00a0tem 3 caracteres;<\/p>\n<\/li>\n<li data-start=\"3604\" data-end=\"3672\">\n<p data-start=\"3606\" data-end=\"3672\">A fun\u00e7\u00e3o LEN(A2) vai retornar 10 (n\u00famero total de caracteres);<\/p>\n<\/li>\n<li data-start=\"3673\" data-end=\"3766\">\n<p data-start=\"3675\" data-end=\"3766\">Voc\u00ea usa LEFT para extrair os <strong data-start=\"3707\" data-end=\"3722\">7 primeiros<\/strong> (10 &#8211; 3 = 7), ou seja, tudo antes do -RJ.<\/p>\n<\/li>\n<\/ul>\n<p>=LEFT(A2, LEN(A2)-3)<\/p>\n<p>Resultado: ID1234<\/p>\n<p>Essa abordagem \u00e9 \u00f3tima quando o conte\u00fado \u00fatil da <em>string<\/em> varia de tamanho, mas o final \u00e9 sempre fixo.<\/p>\n<h2 data-start=\"3933\" data-end=\"3970\">4. Aplicando essas fun\u00e7\u00f5es do Excel juntas, na pr\u00e1tica<\/h2>\n<p data-start=\"3972\" data-end=\"4012\">Veja como essas fun\u00e7\u00f5es se complementam:<\/p>\n<ul data-start=\"4014\" data-end=\"4310\">\n<li data-start=\"4014\" data-end=\"4100\">\n<p data-start=\"4016\" data-end=\"4100\">Use XLOOKUP\u00a0para <strong data-start=\"4035\" data-end=\"4069\">buscar um dado em outra tabela<\/strong> com base em um valor extra\u00eddo;<\/p>\n<\/li>\n<li data-start=\"4101\" data-end=\"4165\">\n<p data-start=\"4103\" data-end=\"4165\">Use RIGHT para <strong data-start=\"4120\" data-end=\"4150\">pegar sufixos padronizados<\/strong>, como estados;<\/p>\n<\/li>\n<li data-start=\"4166\" data-end=\"4222\">\n<p data-start=\"4168\" data-end=\"4222\">Use LEFT+LEN\u00a0para <strong data-start=\"4190\" data-end=\"4221\">remover partes finais fixas<\/strong>;<\/p>\n<\/li>\n<li data-start=\"4223\" data-end=\"4310\">\n<p data-start=\"4225\" data-end=\"4310\">Combine as fun\u00e7\u00f5es para montar uma rotina mais limpa, r\u00e1pida e automatizada no Excel.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"4312\" data-end=\"4474\">Thales finaliza o v\u00eddeo dizendo: \u201c<em>A maneira mais f\u00e1cil de extrair a parte \u00fatil de um texto \u00e9 remover o que voc\u00ea n\u00e3o quer. LEFT + LEN faz isso com poucos cliques.<\/em>\u201d<\/p>\n<h2 data-start=\"4481\" data-end=\"4518\">Quer ver isso sendo feito ao vivo?<\/h2>\n<p data-start=\"4520\" data-end=\"4689\">No v\u00eddeo completo do quadro <em data-start=\"4548\" data-end=\"4568\">INPOworker Explica<\/em>, nosso analista Thales mostra esse passo a passo com exemplos pr\u00e1ticos, simulando uma situa\u00e7\u00e3o real de an\u00e1lise de dados.<\/p>\n<p data-start=\"4691\" data-end=\"4753\"><strong data-start=\"4694\" data-end=\"4753\"><a class=\"cursor-pointer\" href=\"https:\/\/www.youtube.com\/watch?v=o0zoYCWfu9k\" rel=\"noopener\" data-start=\"4696\" data-end=\"4751\">Clique aqui para assistir no YouTube<\/a><\/strong><\/p>\n<h2 data-start=\"4760\" data-end=\"4772\">Conclus\u00e3o<\/h2>\n<p data-start=\"4774\" data-end=\"5042\">Por fim, combinar XLOOKUP, LEFT, RIGHT e LEN \u00e9 uma forma inteligente de ganhar tempo, evitar erros e dominar o Excel de verdade. Em vez de decorar f\u00f3rmulas, voc\u00ea passa a entender o racioc\u00ednio por tr\u00e1s das fun\u00e7\u00f5es, aplicando elas conforme o contexto do seu trabalho.<\/p>\n<p data-start=\"5044\" data-end=\"5188\">Ent\u00e3o, se voc\u00ea quer transformar planilhas em ferramentas poderosas de an\u00e1lise, comece por essas quatro fun\u00e7\u00f5es. Elas j\u00e1 fazem uma enorme diferen\u00e7a.<\/p>\n<p data-start=\"5044\" data-end=\"5188\"><a href=\"https:\/\/inpo.com.br\/en\/contato\/\">Entre em contato<\/a> com nossos especialistas e veja como a tecnologia pode apoiar sua opera\u00e7\u00e3o log\u00edstica na pr\u00e1tica!<\/p>","protected":false},"excerpt":{"rendered":"<p>Saber usar uma f\u00f3rmula j\u00e1 ajuda, mas entender como combinar fun\u00e7\u00f5es do Excel \u00e9 o que realmente transforma seu n\u00edvel de produtividade. Neste artigo, nosso analista Thales Wruck mostra como unir as fun\u00e7\u00f5es XLOOKUP, LEFT, RIGHT e LEN para resolver problemas comuns, como localizar, extrair e analisar dados com rapidez e precis\u00e3o. Quando usar essas [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[35],"tags":[],"class_list":["post-1825","post","type-post","status-publish","format-standard","hentry","category-inpoworker-explica"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!<\/title>\n<meta name=\"description\" content=\"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/inpo.com.br\/en\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!\" \/>\n<meta property=\"og:description\" content=\"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inpo.com.br\/en\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/\" \/>\n<meta property=\"og:site_name\" content=\"INPO\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/INPOeng\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-01T17:48:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inpo.com.br\/wp-content\/uploads\/2025\/03\/Logo-1200x675px.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nicolau\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nicolau\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/\"},\"author\":{\"name\":\"Nicolau\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#\\\/schema\\\/person\\\/f374e09b3d5399505907df5ceb33020d\"},\"headline\":\"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!\",\"datePublished\":\"2025-08-01T17:48:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/\"},\"wordCount\":783,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#organization\"},\"articleSection\":[\"INPOworker Explica\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/\",\"url\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/\",\"name\":\"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#website\"},\"datePublished\":\"2025-08-01T17:48:15+00:00\",\"description\":\"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/blog\\\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/inpo.com.br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#website\",\"url\":\"https:\\\/\\\/inpo.com.br\\\/\",\"name\":\"INPO\",\"description\":\"Otimiza\u00e7\u00e3o Log\u00edstica Sob Medida\",\"publisher\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#organization\"},\"alternateName\":\"INPO - Intelig\u00eancia de Neg\u00f3cios e Pesquisa Operacional\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/inpo.com.br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#organization\",\"name\":\"INPO\",\"alternateName\":\"INPO - Intelig\u00eancia de Neg\u00f3cios e Pesquisa Operacional\",\"url\":\"https:\\\/\\\/inpo.com.br\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/inpo.com.br\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Logo-696x696-1.png\",\"contentUrl\":\"https:\\\/\\\/inpo.com.br\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Logo-696x696-1.png\",\"width\":696,\"height\":696,\"caption\":\"INPO\"},\"image\":{\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/INPOeng\",\"https:\\\/\\\/www.instagram.com\\\/inpo.oficial\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@inpo-suporteadecisaosobmed4022\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/#\\\/schema\\\/person\\\/f374e09b3d5399505907df5ceb33020d\",\"name\":\"Nicolau\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/inpo.com.br\\\/wp-content\\\/litespeed\\\/avatar\\\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063\",\"url\":\"https:\\\/\\\/inpo.com.br\\\/wp-content\\\/litespeed\\\/avatar\\\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063\",\"contentUrl\":\"https:\\\/\\\/inpo.com.br\\\/wp-content\\\/litespeed\\\/avatar\\\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063\",\"caption\":\"Nicolau\"},\"url\":\"https:\\\/\\\/inpo.com.br\\\/en\\\/blog\\\/author\\\/inpodados\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!","description":"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.","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:\/\/inpo.com.br\/en\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/","og_locale":"en_US","og_type":"article","og_title":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!","og_description":"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.","og_url":"https:\/\/inpo.com.br\/en\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/","og_site_name":"INPO","article_publisher":"https:\/\/www.facebook.com\/INPOeng","article_published_time":"2025-08-01T17:48:15+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/inpo.com.br\/wp-content\/uploads\/2025\/03\/Logo-1200x675px.png","type":"image\/png"}],"author":"Nicolau","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nicolau","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/#article","isPartOf":{"@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/"},"author":{"name":"Nicolau","@id":"https:\/\/inpo.com.br\/#\/schema\/person\/f374e09b3d5399505907df5ceb33020d"},"headline":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!","datePublished":"2025-08-01T17:48:15+00:00","mainEntityOfPage":{"@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/"},"wordCount":783,"commentCount":0,"publisher":{"@id":"https:\/\/inpo.com.br\/#organization"},"articleSection":["INPOworker Explica"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/","url":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/","name":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!","isPartOf":{"@id":"https:\/\/inpo.com.br\/#website"},"datePublished":"2025-08-01T17:48:15+00:00","description":"Aprenda a combinar as fun\u00e7\u00f5es do Excel XLOOKUP, LEFT, RIGHT e LEN para buscar dados, extrair textos e automatizar tarefas com rapidez.","breadcrumb":{"@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/inpo.com.br\/blog\/funcoes-do-excel-como-usar-xlookup-e-outras-juntas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/inpo.com.br\/"},{"@type":"ListItem","position":2,"name":"Fun\u00e7\u00f5es do Excel: como usar XLOOKUP e outras juntas!"}]},{"@type":"WebSite","@id":"https:\/\/inpo.com.br\/#website","url":"https:\/\/inpo.com.br\/","name":"INPO","description":"Otimiza\u00e7\u00e3o Log\u00edstica Sob Medida","publisher":{"@id":"https:\/\/inpo.com.br\/#organization"},"alternateName":"INPO - Intelig\u00eancia de Neg\u00f3cios e Pesquisa Operacional","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/inpo.com.br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/inpo.com.br\/#organization","name":"INPO","alternateName":"INPO - Intelig\u00eancia de Neg\u00f3cios e Pesquisa Operacional","url":"https:\/\/inpo.com.br\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/inpo.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/inpo.com.br\/wp-content\/uploads\/2025\/03\/Logo-696x696-1.png","contentUrl":"https:\/\/inpo.com.br\/wp-content\/uploads\/2025\/03\/Logo-696x696-1.png","width":696,"height":696,"caption":"INPO"},"image":{"@id":"https:\/\/inpo.com.br\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/INPOeng","https:\/\/www.instagram.com\/inpo.oficial\/","https:\/\/www.youtube.com\/@inpo-suporteadecisaosobmed4022"]},{"@type":"Person","@id":"https:\/\/inpo.com.br\/#\/schema\/person\/f374e09b3d5399505907df5ceb33020d","name":"Nicolau","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/inpo.com.br\/wp-content\/litespeed\/avatar\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063","url":"https:\/\/inpo.com.br\/wp-content\/litespeed\/avatar\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063","contentUrl":"https:\/\/inpo.com.br\/wp-content\/litespeed\/avatar\/6da579762469d71232a2ed2f38329543.jpg?ver=1792637063","caption":"Nicolau"},"url":"https:\/\/inpo.com.br\/en\/blog\/author\/inpodados\/"}]}},"_links":{"self":[{"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/posts\/1825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/comments?post=1825"}],"version-history":[{"count":1,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/posts\/1825\/revisions"}],"predecessor-version":[{"id":1827,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/posts\/1825\/revisions\/1827"}],"wp:attachment":[{"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/media?parent=1825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/categories?post=1825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inpo.com.br\/en\/wp-json\/wp\/v2\/tags?post=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}