Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

And then see this on how to get the result your after:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"K2hunter" wrote in message
...
I have two colums
SYMBOL NUMBER
O 16
H 1
C 12

When i do a Dropdown list of symbols on another sheet how do i populate
the
corresponding data so that I pick any from Symbol and the number pops up
next to it?