Equal 0 when 0 and blank when blank

Hello

I am using the following formual which is working great =(HLOOKUP($F$7&" "&$F$12,'Specification Data'!$A$4:$G$41,MATCH(A34,'Specification Data'!$A$4:$A$41,0),FALSE)) However sometimes the answer is blank and the formual is returning 0, which dealing with in its self ifs fine, however sometimes the anwer is 0. What i want is if the answer is blank to return a blank cell, but if the anser is 0 to return 0

Thanks for any help

Andy

Spot on, Thanks, that has worked. I have tried so much with IF and ="" etc but just couldnt get it to work, i can see where i was going wrong now, as i was putting it at the end not the middle.

Thanks again