Let's say the cell you want to check for the number 1 in it is D4 and you
want D5 to display "sc" whenever D4 is 1, then put this formula in D5...

=IF(D4=1,"sc","")

In other words, you don't (can't) push a value into another cell from the
cell you are in; rather, you have that other cell look into a specific
location and react to what is in it.

--
Rick (MVP - Excel)


"markwmansell" wrote in message
...
can i link cells so when ever i put can 1 in a cell it will auto put sc in
the cell next to it?