ExcelBanter - IF Function Returning Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Function Returning Range (https://www.excelbanter.com/excel-discussion-misc-queries/202665-if-function-returning-range.html)

Brian

IF Function Returning Range

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?

All times are GMT +1. The time now is 10:27 AM.