Adding IF to an Array formula

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

Hi,

May be this?

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

Thanks, I will give it a try

Dave

format as

0;-0;;@

Yes, it works. Thanks very much

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.