How to pop up correspoding values by clicking on drop down menu?
 

I've got a drop down menu but i want to collarate each item on drop down menu
to a certain value. Like if i click oxygen it corresponding molecular weight
is 16. Any suggestion would be helpful

How to pop up correspoding values by clicking on drop down menu?
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"vin" wrote in message
...
I've got a drop down menu but i want to collarate each item on drop down
menu
to a certain value. Like if i click oxygen it corresponding molecular
weight
is 16. Any suggestion would be helpful