View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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