Is it possible to make two validation lists interact with eachother?
Example:
A1 = "cat", A2 = "dog", A3 = "bird", A4 = "frog", A5 = "fish"
B1 = "Code 14", B2 = "Code 47", B3 = "Code 21", B4 = "Code 34", B5 = "Code 56"
Range A1:A5 has been named "the_animals". Range B1:B5 has been named...