| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
