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 Moderator Last seen December 27, 2022 - Jul 11, 2019 at 11:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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
- Transfer data from one excel worksheet to another automatically - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
- Google sheet right to left - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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