| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation based on data to left but several columns dependen
I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen Oranges in column A, I want the choices in column B to be Valencia/Blood, etc.; if I chose Apples in column A, then I want the column B choices to be Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula in B1; however, I now want to expand to columns C, D, etc., so that if I have chosen Gala in B1, then I have choices in column C, and on and on. HELP! Thanks! Marv Lusk Boise Corporation |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| imported data has weird columns on left | Excel Discussion (Misc queries) | |||
| Different validation list based on cellvalue on the left | Excel Worksheet Functions | |||
| create a data-series based on two different columns of data ? | Charts and Charting in Excel | |||
| DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
| Hide Columns based on a Data Validation List | Excel Programming | |||
Threaded Mode
