You'll have to give more info. Do you mean that when one value from the drop
down is chosen, you want a specific thing to appear in an adjacent cell?
If so, a standard VLOOKUP or INDEX/MATCH will accomplish this.
How is your drop down created? IF you manually inserted values into a
Validation List, perhaps you could use a chart on your sheet instead?
---M------N---
1-red------dog--
2-blue-----cat--
3-teal-----bird--
For a validation list in cell B2 you could use =$M$1:$M$3 and your three
choices would be
red
blue
teal
Then in an C2, you could watch B2 and pull over the associated value:
=index($N$1:$N$3,match(B2,$M$1:$M$3,0))
If you choose BLUE in B2, then "cat" would appear in C2. Is this what you
had in mind?
