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

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