Forum Discussion
ZAle10
Jun 10, 2021Copper Contributor
ProcV with #N/D same with value. How I Solve it?
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.