Validation needs can vary depending on the context in which the validation is used. However, you can create a spreadsheet in which one validation list changes depending on what you select in another.
To make this hack work, the first
thing you need to do is set up a worksheet with some data. On a clean
worksheet named Lists and located in cell A1, type the heading
Objects
. In cell B1, type the heading
Corresponding List
. In cells A2:A5, repeat the
word Can
. In cells A6:A9, repeat the word
Sofa
. In cells A10:A13, repeat the word
Shower
. In cells A14:A17, repeat the word
Car
. Then, starting with cell B2 and ending
with cell B17, enter the following words (corresponding to the
Objects list):