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

Occasional Visitor






1 Reply


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.