#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |