Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2011, 04:51 AM
click4akshay click4akshay is offline Conditional data validation (list drop-down) Windows XP Conditional data validation (list drop-down) Office 2007
Novice
Conditional data validation (list drop-down)
 
Join Date: Apr 2011
Posts: 2
click4akshay is on a distinguished road
Question Conditional data validation (list drop-down)


Hi everyone,

I am a newbie in the forum.

I am struggling to achieve conditional data validation in Excel 2007.

Data -
Please see attachment.

Here is what I want to achieve:

Cell 1 - Select estate type - This I have put list using data validation.
Cell 2 - Select building type - Based on the selection in the cell above, I want only the corresponding building types to appear in the list dropdown

E.g. If Cell 1 - Catering, Cell 2 should show only the relative [Fast Food Restaurants,Public Houses,Restaurants (with Bar), and Restaurants (in Public Houses)] in the list

I am aware that it can be done with 'IF' function but as I understand one can have only 7 nested 'IF's and number of estate types is far greater than 7.

Please help.

Thanks,
AK
Attached Images
File Type: jpg query.JPG (57.8 KB, 40 views)

Last edited by click4akshay; 04-28-2011 at 06:13 AM. Reason: additional info
Reply With Quote
  #2  
Old 04-28-2011, 06:04 AM
macropod's Avatar
macropod macropod is offline Conditional data validation (list drop-down) Windows 7 32bit Conditional data validation (list drop-down) Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi AK,

See the attached demonstration of the concept.
Attached Files
File Type: zip Dependent Dropdowns.zip (66.1 KB, 133 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-28-2011, 01:51 PM
click4akshay click4akshay is offline Conditional data validation (list drop-down) Windows XP Conditional data validation (list drop-down) Office 2007
Novice
Conditional data validation (list drop-down)
 
Join Date: Apr 2011
Posts: 2
click4akshay is on a distinguished road
Default Thanks a ton

Quote:
Originally Posted by macropod View Post
Hi AK,

See the attached demonstration of the concept.
Hi Macropod,

Thanks a lot for the solution.
Very interesting use of 'OFFSET' function.
Learnt a great deal.

Kudos,
AK
Reply With Quote
Reply

Tags
drop-down, excel 2007, list

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down List Box hbradshaw Word VBA 0 09-27-2010 06:24 AM
Drop Down List and Functions (Linking) sten Excel 0 03-17-2010 03:03 PM
Long List for drop down box DLo99 Word 0 02-28-2010 08:07 AM
Conditional data validation (list drop-down) Conditional Expression that Moves Data (challenging) themangoagent Excel 1 02-20-2010 11:29 AM
Trouble With Data Validation And Filtering On A Dropdown zura04 Excel 0 10-24-2006 12:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft