Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2011, 12:22 PM
Klyxrastafari Klyxrastafari is offline Data validation with IF Windows 7 32bit Data validation with IF Office 2007
Novice
Data validation with IF
 
Join Date: Sep 2011
Posts: 2
Klyxrastafari is on a distinguished road
Default Data validation with IF

Hi. I have a problem with data validation in excel using IF condition



sorry for my bad english can't really describe my problem. you will have to see the file to understand the problem.

failiem.lv/down.php?i=quouakh&n=Pirmais_uzdevums.xls

So I have two functions in H3 and I3 I want to create a Data Validation for Cloumn G "Subtype" Allow "List" and Source "=$H$3:$I$3" but it doesn't work like it should... Excel just paste's the correct options for first statemant. If i choose Meal it shows Food Drink and for next i.e. Education it again shows Food and Drink but I Need "Fees" and "Books". I have tried tons of ways but i still cant get it work the right way!
Reply With Quote
  #2  
Old 10-03-2011, 04:41 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Data validation with IF Windows 7 32bit Data validation with IF Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Here's one way:

http://www.contextures.com/xlDataVal02.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation with IF Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM
Powerpoint: adding data to trend lines w/o data labels HaiLe PowerPoint 0 04-11-2011 09:21 AM
Outlook userform validation help aiwnjoo Outlook 0 12-08-2010 12:57 AM
Data validation with IF Validation for length and numeric type chamsy Excel 1 10-22-2010 07:31 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 08:06 PM.


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