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?
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?
For this there is the formula SEERRO
. In it you can configure a condition in case you get an error. The first argument is where you write the formula that could eventually generate an error, and in the second argument vc declares what happens if an error occurs in the first argument. If it does not return an error, the formula returns the result of the first argument.
=SEERRO( PROCV() ; "")
=SEERRO( PROCV( Argumento procurado ; Tabela de procura ; índice da coluna a retornar o valor ; FALSO/VERDADEIRO ) ; resultado caso PROCV retorne em erro )
There are thousands of pages on the internet about this formula. It is considered basic.