#N/A

[ExcelRoy]

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

 

[Joe4]

You can use the ISNA function, i.e.

=IF(ISNA(formula),"",formula)
replace the two formula references with your formula

 

[Brian from Maui]

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

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

 

[ExcelRoy]

Tried but cannot get to work

=IF(ISNA(=INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0)),"",=INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0))

Sorry, but i cannot get this to work?

regards

 

[Joe4]

You should only put an equal sign at the very beginning of your formula, and whatch your parentheses i.e.

=IF(ISNA(INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0),"",INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0))