Copying Excel data from one sheet to another based upon contents of a cell
Closed
                    
        
                    DittDott
    
        
                    Posts
            
                
            2
                
                            Registration date
            Monday July  8, 2019
                            Status
            Member
                            Last seen
            July 10, 2019
            
                -
                            Jul  8, 2019 at 10:51 PM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 11, 2019 at 11:42 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 11, 2019 at 11:42 AM
        Related:         
- Copying Excel data from one sheet to another based upon contents of a cell
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- Excel hyperlink to another sheet - Guide
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Jul 9, 2019 at 11:45 AM
    Jul 9, 2019 at 11:45 AM
                        
                    Hi DittDott,
Excel has the VLOOKUP function for that.
Formula for Sheet2 C2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,2,0)
Formula for Sheet2 D2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,3,0)
Formula for Sheet2 E2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,4,0)
Adjust the range $A$2:$D$6 to match yours, check the results, then select C2, D2 and E2 and drag the formulas down as far as needed.
Best regards,
Trowa
            Excel has the VLOOKUP function for that.
Formula for Sheet2 C2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,2,0)
Formula for Sheet2 D2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,3,0)
Formula for Sheet2 E2:
=VLOOKUP(B2,Sheet1!$A$2:$D$6,4,0)
Adjust the range $A$2:$D$6 to match yours, check the results, then select C2, D2 and E2 and drag the formulas down as far as needed.
Best regards,
Trowa
 
        
    
    
    
    
Jul 10, 2019 at 06:13 PM
Jul 11, 2019 at 11:42 AM