I have an IF Function that if C4 says HUD then it returns the infor in a
range of cells on the HUD worksheet, which is a separate worksheet from where
this formula is.

=IF(C4="HUD",HUD!A1:C100,"")

But now, on the cells that it is returning, it puts 0 in cells that are
blank on the other worksheet. What can I add to this formula to eliminate
that?