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)
=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)