| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering a value into a cell with a formula or by tying the value
I have a drop down list in E4 with the following options, Survival,
Operational, Transitional and Manual Entry. Survival, Operational, & Transitional are tables with numerical values. Should one of the tables be selected in E4 I would like a value from said table to appear in D7 but should Manual Entry be selected in E4 I would like to type a number into D7. By using match and vlookup the value wanted from the respective tables are in cells Operational €“ K1 Survival €“ K2 Transitional €“ K3 Thanks Andy G |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Formula - Cannot select cell as it is hidden by formula | Excel Worksheet Functions | |||
| Tying an imported graphic to a cell | Excel Discussion (Misc queries) | |||
| Entering Sum formula into a cell | Excel Programming | |||
| Entering Sum formula into a cell | Excel Programming | |||
| Entering Sum formula into a cell | Excel Programming | |||
Threaded Mode
