If your list is in the range B1:B5 and the dropdown is in cell A1 then use:

=MATCH(A1,B1:B5,0)

You could have used something similar for your original question.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Corey Heidenreich" wrote in message
...
Another Quick Question......
What if the alpha values were actually people names, or city
names......but
yet you wanted to use the numeric values for those?
How would that work?
Corey




"Andy Wiggins" wrote in message
...
A will have to be A. What you can do is interpret that where you need 1
by
using a formula such as:
=CODE(UPPER(A1))-64
This assumes your list is in cell A1.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Corey Heidenreich" wrote in message
...
Hello All,
I'm trying to make a drop down list with alpha values (A thru Z) so
that
if
you select "A", it'll show "A" in the cell but give it a value of 1.
Thus
if you select "B" in the dropdown, it'll show "B" however give it a
value
of
2 and so on.
Anyone have a VBA macro or excel equation that would work for this?
Corey