Thread: Formula so if reference is selected, a specific value is returned.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BOSS BOSS is offline
external usenet poster
  
Posts: 123
Default Formula so if reference is selected, a specific value is returned.
A list with 5 different scenarios each have a specific value next to them.
When a dropdown list with all 5 scenarios is opened and one scenario is
selected, the relevant value appears in an adjacent cell.

Reply With QuoteReply With Quote