Adding Values To Drop Down Menu
 

I have a drop down emnu but a I want to assign a value to each drop down
item...is there a way to do this?

Adding Values To Drop Down Menu
 

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?



--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JI" wrote:

I have a drop down emnu but a I want to assign a value to each drop down
item...is there a way to do this?