Data validation and If statement
Closed
                                    
                        Pedro                    
                                    -
                            Jun  6, 2012 at 04:59 AM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 11, 2012 at 09:40 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 11, 2012 at 09:40 AM
        Related:         
- You may not use reference operators for data validation criteria
- Display two columns in data validation list but return only one - Guide
- Windows genuine validation - Guide
- Tmobile data check - Guide
- Could not complete this operation. there was not enough memory available - Guide
- Data transmission cable - Guide
1 response
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Jun 6, 2012 at 05:27 AM
    Jun 6, 2012 at 05:27 AM
                        
                    YOU NEED NOT WORRY WHAT IS IN ANOTHER SHEET 
suppose in sheets1 in A1 you have either G0 or G1 or G2
just type in A2 type this formula
="LIST"&A1
and enter
now enter any value in A1 and see what happens in A23
            suppose in sheets1 in A1 you have either G0 or G1 or G2
just type in A2 type this formula
="LIST"&A1
and enter
now enter any value in A1 and see what happens in A23
 
        
    
    
        
    
    
    
Jun 6, 2012 at 05:49 AM
I does not accept the formula inside data validation...
The exact formula I've tried is:
=IF($F$12="1-2 steps";Steps_G25);IF($F$12="2-3 steps";Steps_G25)
It says: "You may not use use reference operators or array constrants for Data Validation criteria"
Jun 6, 2012 at 06:58 AM
=IF($C$4=Lists!$G$22;Lists!$I$5:$I$6;IF($C$4=Lists!$G$23;Lists!$I$5:$I$6;IF($C$4=Lists!$G$39;Lists!$I$4:$I$5;IF($C$4=Lists!$G$4:$G$52;Lists!$G$22:$G$31;"NA"))))
The issue was in the parenthesis. The next if needs to go inside the previous if statement.
BUT the last if doesnt work yet:: what I want is to say again is elseif($C$4="NA")
Jun 11, 2012 at 09:40 AM
Why don't you refer to a cell containing the text "NA", so that when the conditions are not met, only "NA" will be able to be seletected from dropdownlist?
Best regards,
Trowa