Formula

Hello,

Hi, I'm looking to get these results in an excel file. I have a list of names that have ID's accociated with them. I'd like to have a column that when you type in the name it automatically places the id in the column next to it.

I hope I make sense.

IE:
a=1, b=2, c=3, d=4,... ect.

Now in a column I have
a
c
b
e
f
h

I'd like a formula so that when it sees a it puts 1 in the adjacent column. c it puts 3, b it puts 2 and so on.

thanks for any help you can be.