Data Validation

[K2hunter]

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?

 

[T. Valko]

Watch this 5 min video:

How to setup a data validation drop down list:

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

http://contextures.com/xlFunctions02.html