Searching a cell and setting another cell
Closed
                                    
                        stacks                    
                                    -
                            Apr 23, 2010 at 09:09 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:48 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:48 PM
        Related:         
- Searching a cell and setting another cell
 - Cell phone codes - Guide
 - Excel cell color formula - Guide
 - Google searching in another country - Guide
 - Based on the cell values in cells b77 ✓ - Excel Forum
 - Redial setting in android - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Apr 23, 2010 at 12:48 PM
    Apr 23, 2010 at 12:48 PM
                        
                    Use IF statements
=IF(A2="roadmap","roadmap",IF(OR(A2="startup",A2="feasibility",A2="definition"),"Planning",IF(OR(A2="Build",A2="deploy"),"Building","none of the choice")))
            =IF(A2="roadmap","roadmap",IF(OR(A2="startup",A2="feasibility",A2="definition"),"Planning",IF(OR(A2="Build",A2="deploy"),"Building","none of the choice")))