Error en formula

Copper Contributor

Excel version 16.54 Mac

ESTA FORMULA

=SI.ERROR(BUSCARV(REGISTRE!$D$5,DADES,1,FALSO),"")

ME DA ERROR EN $D$5 PORQUÉ ?

1 Reply

@Joan_Lagunas 

Is the sheet name REGISTRE correct? (Without a space before or after the name)

Do you use the A1 adressing system or the R1C1 system?