Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 542
Default list choice depending on the value in another cell

I want to be able to change the list used in validaiton of a cell based the
value in another cell. Scenario, user selects a value in column A using
validation list, cloumn B has If formula, I need column C to present one of
3 lists based on result in column B.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,441
Default list choice depending on the value in another cell

James,

http://www.contextures.com/xlDataVal02.html

HTH,
Bernie
MS Excel MVP


"James" wrote in message
...
I want to be able to change the list used in validaiton of a cell based the
value in another cell. Scenario, user selects a value in column A using
validation list, cloumn B has If formula, I need column C to present one of
3 lists based on result in column B.




Reply
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
choice from a drop down list returns a result to a different cell thunderbunny Charts and Charting in Excel 2 April 12th 08 10:47 PM
Create a RowSource Depending on ComboBox Choice Blobbies Excel Discussion (Misc queries) 3 November 18th 07 01:22 AM
Show pictures in excel depending of a choice! petterss Excel Discussion (Misc queries) 1 August 2nd 06 11:45 AM
add text to cell by clicking a choice in drop down list Microsoft Sidewinder wheel force feedbac New Users to Excel 1 May 23rd 06 06:46 PM
Calculate Value of Cell From Pick List Choice Buz Excel Discussion (Misc queries) 1 April 5th 05 08:52 PM


All times are GMT +1. The time now is 07:52 AM.

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

About Us

"It's about Microsoft Excel"