I need to create a dependent drop-down list but the second list has multiple words and excel doesn't like spaces
the first list is -:
=[name]

the second list is -:

=INDIRECT ($A2)


the third list is -:

=INDIRECT(SUBSTITUTE($B2," ",""))

but this doesn't work when the entry in the second list is
i.e. Toxicology - Single Dose Studies

can anyone please help?