cell ref
 

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?

cell ref
 

On Sun, 16 Nov 2008 09:41:00 -0800, markwmansell
wrote:

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?

If the two cells are A1 and B1, then

B1: =if(a1=1,"sc","")

--ron

cell ref
 

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?

cell ref
 

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.


"Ron Rosenfeld" wrote:

On Sun, 16 Nov 2008 09:41:00 -0800, markwmansell
wrote:

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?

If the two cells are A1 and B1, then

B1: =if(a1=1,"sc","")

--ron

cell ref
 

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?

cell ref
 

Well, that description has a lot more useful information than your first
posting. Put this formula in B1 on Sheet1 and copy it down as far as you
think you need to...

=IF(A1="","",LOOKUP(A1,Sheet2!A$1:A$8,Sheet2!B$1:B $8))

Change the 8 in the A$8 and B$8 to the row number for your last product code
on Sheet2 (so the range covers all your product codes on Sheet2).

--
Rick (MVP - Excel)


"markwmansell" wrote in message
...
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?

cell ref
 

On Sun, 16 Nov 2008 14:34:00 -0800, markwmansell
wrote:

Well I don’t think that’s what I’m 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. It’s 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.

That's a different description than your first. But we could still use more
data.

Does Sheet2 contain a list of various numbers in column A, and a list of codes
in the adjacent cell in column B?

Do you need to be able to put the 2345 in "any" cell, or will there be specific
cells?

If you have specific cells on Sheet1, then in (all of) the adjacent cell, you
could put a lookup formula: e.g. something like:

b1: =if(a1="","",vlookup(a1,reference_to_table_on_shee t2,2,false))

The reference_to_table_on_sheet2 can be a NAME'd range with workbook scope; or
it can be an address of the type: sheet2!$A$1:$B$100

If you truly mean to be able to put the 2345 in "any" cell, then you will need
to use a VBA event-triggered macro
--ron

cell ref
 

thank you very much that did the trick

"Rick Rothstein" wrote:

Well, that description has a lot more useful information than your first
posting. Put this formula in B1 on Sheet1 and copy it down as far as you
think you need to...

=IF(A1="","",LOOKUP(A1,Sheet2!A$1:A$8,Sheet2!B$1:B $8))

Change the 8 in the A$8 and B$8 to the row number for your last product code
on Sheet2 (so the range covers all your product codes on Sheet2).

--
Rick (MVP - Excel)


"markwmansell" wrote in message
...
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?