Not sure exactly what I need.

[hunter5150]

I have a drop down list with x items in it. I need to have a different cell return a number associated with the choices in the list.

ie. drop down list has cities, cell gives distance in miles from New York.

The cell needs to automatically return associated number anytime list variable changes.

Please help!!

[shg]

Please read the forum rules, then start a new thread with a descriptive title.