Well I dont think thats what Im after let me try again.

say in sheet 1 you put say 2345 in any cell it auto puts SC in the cell next
to it because is looks look in sheet 2 which will have 2345 in say A1 and in
B1 it will have SC in it am I making any sense. Its a bit like having a
list of product codes and products on sheet2, when you put a product code in
sheet1 it puts the product name in for you next to the product code.


"Rick Rothstein" wrote:

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?