Zilla,

How about this, in column D type:

=B1 & "-" & C1

Then, turn auto filters on (Data-Filter-AutoFilter).

That way, you see the 'from-to' representation in Column D and the
autofilter gives you the drop down list.




"Zilla" wrote:

Say I have sheet 1 that has

Rt# O D
----------------
A B C
1 1 a b
2 2 c d

Where col A represents a route#, col B represents
orig, and col C represents dest. In essence Route 1
represents a to b, Route 2 represents c to d routes
respectively.

Now I want to have drop down list on a cell, so the
user sees "a-b", or "c-d", but when he makes a
choice, the cell will contain the route#, instead of the
actual route. IOW, it'll be more user-friendly to "see"
the "from-to" representation of the routes for the user,
but I want to use the corresponding chosen route#
for a calculation later.

Make sense?

-
- Zilla
(Remove XSPAM)