Hi,

The array formula below returns a value in Column B that corresponds to a match for "X" in Column A. If the value in Col A is not "X" a blank cell is returned, as intended. The problem is that when an "X" in Col A has a corresponding empty cell in Col B, a 0 (zero) is returned. How can I have a blank cell (" ") returned instead of the zero. I think it needs another IF but can't figure out how to do it in an array formula.


{=IF(Sheet2!A$2:A$7="X",Sheet2!B$2:B$7, " ")}


Thanks very much

Dave