I want to be able to out from one cell to multiple cells i.e. something like

in cell B: =IF(<condition,output some text to cells A B, "")

the problem with turning this around (in the 'normal' spreadsheet manner) is
that a condition in cell A woulld involve a large number of cells (i.e.
hundreds) in a row but when the condition is in cell B is is far simpler.
This must be a common problem but I cannot see a 'simple' solution.

Thanks in advance.
Kevin

You are not clear, give a (reduced) example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"k_d_w" wrote in message
...
I want to be able to out from one cell to multiple cells i.e. something
like

in cell B: =IF(<condition,output some text to cells A B, "")

the problem with turning this around (in the 'normal' spreadsheet manner)
is
that a condition in cell A woulld involve a large number of cells (i.e.
hundreds) in a row but when the condition is in cell B is is far simpler.
This must be a common problem but I cannot see a 'simple' solution.

Thanks in advance.
Kevin