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
Bookmarks