Say you enter your datalist in Y1 to Z18.

In B1, enter this formula:

=VLOOKUP(A1,$Y$1:$Z$18,2,0)

And you can copy down if needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"dzierzekr" wrote in message
...
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