View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Choose from drop down menu and get defined output in another cell

Look at VLOOKUP.

"NWCrane" wrote:

I have created a drop down menu with several different options included in
it. If I select one of the options, I want a value that I predetermine to
display in the cell next to it. Is there any way to do this?