Not sure if i've understood completely, but can you use a formula i
column ax, =if(av1="N/A",aj1,av1). If your required logic is mor
complex, can you use hidden columns to cascade the logic?
Adria

--
Adrian
-----------------------------------------------------------------------
Adrian G's Profile: http://www.excelforum.com/member.php...fo&userid=3662
View this thread: http://www.excelforum.com/showthread.php?threadid=56374