LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula so if reference is selected, a specific value is returned Boss Excel Discussion (Misc queries) 1 July 24th 07 04:41 AM
limit characters returned a cell reference Lila Excel Worksheet Functions 8 September 6th 06 03:33 AM
A formula for displaying the cell reference of the selected cell Emlou85 via OfficeKB.com Excel Discussion (Misc queries) 3 March 19th 06 03:54 PM
Need reference in adjacent column returned Dan Excel Worksheet Functions 9 March 5th 06 07:05 PM
Specific cell selected when sheet opens...how??? Ron M. Excel Discussion (Misc queries) 3 February 17th 06 02:37 AM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"