Show's #N/A please to showblank.
Thank's Simon.
"SiC" wrote:
=IF(ISNA(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0)),"",SUBSTITUTE(TEXT(VLOOK UP("City",'2nd
Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1)
-Simon
"Steved" wrote:
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.
|