Questions tagged as 'procv'

I have a table of banks and codes in two columns. Ex: Banco do Brasil S / A 001 Bank of the State of Rio Grande do Sul - Banrisul 041 Banco Santander do Brasil 033 Banco Mercantil do Brasil 208 Banco Itaú S / A 341 Some expr...

Good evening, good evening. The formula below is ending in #VALOR! error. The formula is comparing words with a hyphen, I do not know if that influences anything. =SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE WORKFLOW";"")     

I have a database in which an employee has three or more dependents, when I do a PROCV to pull a dependent one at a time, only the first and last one appears. How do I select the first in a column the second in another column and so on? EX...

I have a database where an employee has three or more dependents, when I make a PROCV to pull one dependent at a time, only the first and last one appears. =PROCV(B35;'SÓCIOS COOP'!C:G;5;1) How do I select the first in a column the s...

Is there any configuration in Excel or some way to make the PROCV formula, when it does not find the value fetched, return empty ("") or 0 instead of the "# N / A" error?