{"id":10926,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/proch\/"},"modified":"2021-02-25T17:20:50","modified_gmt":"2021-02-25T17:20:50","slug":"hlookup","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/","title":{"rendered":"PROCH"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o PROCH (Procura Horizontal)<\/h2>\n

A fun\u00e7\u00e3o PROCH \u00e9 amplamente utilizada no Excel e no Google Planilhas para pesquisar dados em uma linha, retornando um valor na mesma coluna de uma linha especificada. Esta fun\u00e7\u00e3o \u00e9 particularmente vantajosa para gerenciar tabelas onde as vari\u00e1veis s\u00e3o organizadas nas linhas e os respectivos dados nas colunas.<\/p>\n

Sintaxe e Funcionamento<\/h2>\n

A sintaxe da fun\u00e7\u00e3o PROCH \u00e9 a seguinte:<\/p>\n

  FUNCAOPROCH(valor_procurado, tabela_array, indice_linha, [procurar_intervalo]) <\/code> <\/pre>\n
    \n
  • valor_procurado:<\/strong> O valor a ser buscado, que deve estar na primeira linha do intervalo de tabela_array.<\/li>\n
  • tabela_array:<\/strong> Intervalo de c\u00e9lulas que cont\u00eam os dados.<\/li>\n
  • indice_linha:<\/strong> O n\u00famero da linha, dentro do intervalo tabela_array, de onde o valor correspondente ser\u00e1 recuperado.<\/li>\n
  • procurar_intervalo:<\/strong> (Opcional) Um valor booleano que determina se a busca ser\u00e1 por uma correspond\u00eancia exata ou aproximada. Se TRUE ou omitido, a fun\u00e7\u00e3o busca uma correspond\u00eancia aproximada. Se FALSE, \u00e9 necess\u00e1ria uma correspond\u00eancia exata.<\/li>\n<\/ul>\n
    Exemplos Pr\u00e1ticos de Uso<\/h2>\n
    Abaixo, apresentamos dois exemplos que ilustram a aplicabilidade efetiva dessa fun\u00e7\u00e3o.<\/p>\n
    Exemplo 1: Encontrando o Pre\u00e7o de um Produto<\/h2>\n
    Considere uma tabela que lista produtos e seus respectivos pre\u00e7os e estoques, conforme mostrado abaixo:<\/p>\n\n\n\n\n\n
    Produto<\/th>\nPre\u00e7o<\/th>\nEstoque<\/th>\n<\/tr>\n
    Arroz<\/td>\n15<\/td>\n200<\/td>\n<\/tr>\n
    Feij\u00e3o<\/td>\n7<\/td>\n150<\/td>\n<\/tr>\n
    Macarr\u00e3o<\/td>\n12<\/td>\n100<\/td>\n<\/tr>\n<\/table>\n
    Para descobrir o pre\u00e7o do “Feij\u00e3o”, usamos a seguinte f\u00f3rmula:<\/p>\n
      =FUNCAOPROCH(\"Feij\u00e3o\", A1:C3, 2, FALSO) <\/code> <\/pre>\n
    Essa f\u00f3rmula procura o termo “Feij\u00e3o” na primeira linha e retorna o valor da segunda linha, que \u00e9 7, indicando o pre\u00e7o do Feij\u00e3o.<\/p>\n
    Exemplo 2: Verificando o Estoque de um Produto<\/h2>\n
    Utilizando a mesma tabela, para verificar a quantidade em estoque do “Macarr\u00e3o”, a f\u00f3rmula seria:<\/p>\n
      =FUNCAOPROCH(\"Macarr\u00e3o\", A1:C3, 3, FALSO) <\/code> <\/pre>\n
    A fun\u00e7\u00e3o busca “Macarr\u00e3o” na primeira linha e retorna o valor na terceira linha, que \u00e9 100, mostrando a quantidade dispon\u00edvel em estoque de Macarr\u00e3o.<\/p>\n
    Essas funcionalidades demonstram o poder das ferramentas de an\u00e1lise e organiza\u00e7\u00e3o de dados, especialmente \u00fateis em grandes volumes de informa\u00e7\u00e3o organizados horizontalmente.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Procura na linha superior de uma matriz e devolve o valor da c\u00e9lula indicada<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[439],"tags":[],"class_list":["post-10926","post","type-post","status-publish","format-standard","hentry","category-consulta-e-referencia"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:20:50+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/\",\"name\":\"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:20:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Consulta e refer\u00eancia\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/consulta-e-referencia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PROCH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/hlookup\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:20:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/","url":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/","name":"Fun\u00e7\u00e3o HLOOKUP (PROCH) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:20:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HLOOKUP (PROCH) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/hlookup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/hlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Consulta e refer\u00eancia","item":"https:\/\/functiontranslator.com\/pt-pt\/consulta-e-referencia\/"},{"@type":"ListItem","position":3,"name":"PROCH"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10926"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10926\/revisions"}],"predecessor-version":[{"id":25755,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10926\/revisions\/25755"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}