Hiding #N/A

[jamie85]

Is there a way that i can hide the #N/A that appers in a cell with
lookup when there is no value in it? Thankyou

 

[Jerry W. Lewis]

=IF(ISNA(<formaula>),"",<formula>)

Jerry

 

[tolgag]

Hi,

Try following ws-function :

=IF(ISNA(your_lookup_function);;your_lookup_function

 

[jamie85]

=IF(ISNA(=VLOOKUP(A2,STOCK,2)),"",=VLOOKUP(A2,STOCK,2))

That is what i currently have but it isn't working. Any idea why
Thanks

 

[tolgag]

should be like this :

=IF(ISNA(VLOOKUP(A2,STOCK,2)),"",VLOOKUP(A2,STOCK,2))

 

[jamie85]

Great that works thanks