When one of the values in column 1 shows up
in cell "A1" I need the value across from it in column 2
to show up in cell "B1".
(I'm using a drop down list to place the value in cell "A1")
What is the best way to do this?

M9-4:30 7.5
M3-C 7
r10-4 6
r11-4 5
r4-C 5.5
w11-4 5
w10-4 6
w4-C 5.5
d11-4 5
d4-C 5.5
d12-9 9
c9-4 7
c4-C 6
c12-4 4
c11-4 5
c4-9 5
c5-9 4
c12-8 8

thanks
dzierzekr