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?

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?