Prevent the PROCV formula from returning an error

Question

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

Answer 1

For that there is the formula SEERRO. In it you can set up a condition if you get an error. The first argument is where you write the formula that can possibly generate an error, and in the second argument you declare what happens if an error occurs in the first argument. If it does not return in error, the formula brings 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.