Can someone please help,

Is there any way to not show the error "#N/A" when a formula is waiting for criteria

my formula is ;

=INDEX(Supplier!$C$5:$C$505,MATCH(B12,Supplier!$A$5:$A$505,0),0)

and works fine when i enter a line, but until i enter the line it shows #N/A and looks un professional

Any ideas

Kind Regards