| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the data validation list range of one cell be driven by theco
Hi Bony,
I'm struggling with this. If I do Col A Col B 1 Player_1 =indirect(a1) the result of =indirect(a1) is #REF! Regards, Ciarán |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can the data validation list range of one cell be driven by th
Hi Ciarán,
The indirect formula needs to be entered in the Data Validation dialogue. Select Data Validation, Select LIST and type the indirect formula into the box. Player_1 must be a named range including the sports Player_1 can play. HTH Regards, Bony "Ciarán" wrote: Hi Bony, I'm struggling with this. If I do Col A Col B 1 Player_1 =indirect(a1) the result of =indirect(a1) is #REF! Regards, Ciarán |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
| data validation list selected from a range | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
Linear Mode
