Forum Discussion

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.

Resources