LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BKO BKO is offline
external usenet poster
 
Posts: 15
Default Different validation list based on cellvalue on the left

Hello, I have a list with values,
I want to create validation list for each cell [b] depending on value in cel
[A]
[A] [b] [D] [E] [F]
[G]
[1] DI16 select from [D1]:[F1] DIa DIb DIc
[2] DO16 select from [D2]:[F2] DOa DOb DOc
[3] DI4 select from [D3]:[E3] DIa DIb
[4] AI1 select from [D4]:[G4] AIa AIb AIc AId

The values in [D] through [G] are calculated

Can some one help me with this, Cause I'm getting stuck

THanks a lot in advance

--

There are only 10 types of people in the world:
Those who understand binary and those who don''t.

 
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
Creating a Data Validation List based on a Value in another cell LondonLion Excel Worksheet Functions 2 June 8th 07 12:23 AM
Automating Address Information based on selecting data via a validation list BrownsFan Excel Worksheet Functions 2 January 11th 07 10:09 PM
validation list - filter based on selection jen Excel Worksheet Functions 2 June 22nd 06 02:52 AM
data validation list should have opt. to select based on criteria be Excel Worksheet Functions 1 September 15th 05 01:05 PM
DATA VALIDATION with LEFT function Gabe Excel Discussion (Misc queries) 2 May 6th 05 06:37 PM


All times are GMT +1. The time now is 02:23 PM.

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"