| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add in numbers automatically based on adjacent cells cont
I'm trying to automatically enter data into multiple cells based on one cells
data. For instance if a cell in column A = 1 then the adjacent cells in columns B, C and D will all have specific values which will be true for a value of 1 in column A. If the value in the cell in column A = 2 then the adjacent cells in columns B, C and D will have another set of specific values which will be true for a value of 2 in column A and so on. I think lookup tables is possibly the answer but the help isn't much good and I am struggling! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
| calculate numbers based on font color? | Excel Worksheet Functions | |||
| I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
