| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate Adjacent Cells based on Pull Down Selection
Index Match will give you the solution.
edvwvw Ambassador wrote: I have a spread sheet where col A is a "Level Of Training" named range ("LOT") pull down selection built in the Validation List box. Dependent upon LOT selected for that row, I need the col B (labeled T1), col C (labeled T2), etc through col G (labeled T6) to be populated with a number (0-5). The number is put in each column again is dependent on the LOT selection. Example: LOT= TSTA, col B = 1, col C = 3, ... Col A B C D... TSTA 1 1 3... GS 3 2 1... . . Now for the fun part....if the number is 0 (zero) then I want the font color to be light grey. I tried to do a case select statement but just get 0 in all cells.... please help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200906/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
| Auto Populate Based on Other Selection | Excel Discussion (Misc queries) | |||
| populate fields based upon pull down lists | Excel Worksheet Functions | |||
| Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
| need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
Linear Mode
