The formula below returns the correct value and removes the #NA but not the null values.
How do I remove “0” null?
=IFERROR(INDEX('[request.xlsm]Notes'!$A:$K,MATCH($C2,'[request.xlsm]Notes'!$B:$B,0),11),"")
Aucun commentaire:
Enregistrer un commentaire