drop down list with multiple dependencies

[projectile]

I want to know if it's possible to have a drop down list which depends on EITHER of the mulitple dependency lists.

At the moment Im using =INDIRECT(A1) which populates a drop down list based what is chosen in a single cell reference A1

But I want a drop down list based on what is chosen in cell A1, A2 OR A3; so in essence will amalgamate one huge list from the lists chosen in cells A1 A2 A3 NOT a narrowed down list.

Please help!

 

[Dannyh1]

Hi,

Try defining another name (e.g. ALL) & combining the 3 cells

=INDIRECT('Sheet1'!$A$1),INDIRECT('Sheet1'!$A$2),INDIRECT('Sheet1'!$A$3)

then your dropdown list:

=ALL