Well in your second post c236 has become c$36, but that is probably just
a typo
If it is copying the formula sideways
=if($C236="c",column($C236),if($T$236="c",column
($O236),if($C236="c",column($O236),

Although you have not posted your full expression above so it is
diffiicult to see also the logic is trange as if the first condition
c36="c" is satisfied (highlighted in green) the other conditions will
not be so the last bit of the expression can never occur (highlighted
in red.)

Maybe you state in english clearly what you want to do and include an
example

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=565033