Data validation with multiple dependants?

[Onyxalis]

Hi,

Is it possible to use data validation based on the prior result in more than one cell?

Example:
I have four types of pipes and all of them can be made out of either steel or copper.
I would like to be able to pick a pipe dimension, from a list, based on the combination of type AND material. (Type and dimension are picked in different cells) Is this possible?

In the attached file The orange cells are the dependants and the green is where I want my dimension to go. The different dimensions can be found in the "Data" tab

(The texts are in Swedish, sorry about that)

Thanks in advance
//Jenny

[ragulduy]

I'm getting a bit lost without all the swedish but as a simple example:
in a blank sheet:
enter:
A1: 1
A2: 2
A3: 3
B1: a
B2: b
then assign a named range "ab" to A1:A3 and in B3 apply data validation formula:
=indirect(B1&B2)
this will then give you data validation list linked to the named range of B1 and B2 together, in this case A1:A3.

[Onyxalis]

Thank you!

In the attached file you can see how I solved the problem (translated to English )

That brings me to a new question; What if I needed to have spaces separating the different words in the list. For example "FlexibleTwin" needs to be "Flexible Twin" in the drop down list. Can I still use the INDIRECT funktion?
I have been trying something like this: =INDIRECT((SUBSTITUTE(B19," ","")&B20)) It will not work, though.

//Jenny

[ragulduy]

I don't see why that wouldn't work, to go back to the simpler example:
A1: 1
A2: 2
A3: 3
B1: a b
B2: c
then assign a named range "abc" to A1:A3 and in B3 apply data validation formula:
=indirect(substitute(B1&B2," ",""))

That seems to work ok for me.