Show's #N/A please to showblank.

[Guest]

Hello from Steved

How can I make the below formula please to show blank cells in stead off #N/A

=SUBSTITUTE(TEXT(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1

Thankyou.

 

[Guest]

=IF(ISNA(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0)),"",SUBSTITUTE(TEXT(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1)

-Simon

 

[Guest]

Thank's Simon.

=IF(ISNA(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0)),"",SUBSTITUTE(TEXT(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1)

-Simon