ProcV with #N/D same with value. How I Solve it?

Copper Contributor

 

ZAle10_1-1623354955501.png

ZAle10_0-1623355241622.png

 

 

1 Reply

@ZAle10 

The PROCV function starts to look in Tabela!C153, but CAREACU is in Tabela!C149

Go to the very first cell with a PROCV formula in column F, and "fix" the lookup range by selecting it in the formula and pressing F4. It should look similar to this:

 

=PROCV(E2, Tabela!$C$2:$D$1662, 2, FALSO)

 

(the exact range depends on where you begin).

Fill down.