Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |