Formula

[Pjesani]

How do get to display blank for values that are zeros or null in the formula below

=HLOOKUP($I8,'O:\Store\estman\Exportdirectory\[Export data file.xls]Export_data'!$A$1:$IT$45,MATCH(J$1,'O:\Store\estman\Exportdirectory\[Export data file.xls]Export_data'!$A$1:$A$45,0),FALSE)

 

[Aladin Akyurek]

Custom format the formula cell as:

[=0]"";General

 

[P Sitaram]

Since you are referring to an external file, it is best to add another column with a formula:

=IF(OR(ISERROR(A1),A1=0),"",A1)

 

[Ed B. Delen]

Hi its simple one...

just click : format, options click on zero values(should be unchecked)

ed