Thread: Can selection from text drop-down dictate value in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Relating text to values in drop-downs Relating text to values in drop-downs is offline
external usenet poster
  
Posts: 1
Default Can selection from text drop-down dictate value in another cell
I am working in Excel. I have created a text drop-down menu in one column.
Can I insert a function so that when a choice is made, a value automatically
appears in another cell i.e. choosing Monday in Cell D1 brings up 100 in cell
E1, choosing Tuesday in Cel D1 brings up 200 in E1 etc...
Reply With QuoteReply With Quote