interactive validation lists?

[Mannix]

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 "the_codes".

C1 contains a validation list with source = "the_animals"
D1 contains a validation list with source = "the_codes"

What I would like to happen is this:
- someone knows the type of animal, selects it in C1 and automatically the corresponding code appears in D1
- someone else only knows the code, selects it in D1 and automatically the right animal type appears in C1

I'm rather new to Excel, so maybe this is a stupid question. However, Googling for an answer did not bring any solution.

 

[Domski]

Have a look here: http://www.contextures.com/xldataval02.html

Dom