Transferring Data Between Two ExcelWorksheets
Closed
Truetide
-
Mar 4, 2010 at 12:12 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 12:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 12:19 PM
Related:
- Transferring Data Between Two ExcelWorksheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 4, 2010 at 12:19 PM
Mar 4, 2010 at 12:19 PM
Assuming your sheet one look like
Col A : Route
Col B : ID
And your sheet 2 look like
Col A: BLANK
Col B : Route
Use VLOOKUP in Sheet 2
AS
=VLOOKUP(B2, sheet1!A:B, 2, false)
If sheet 1 is like
COL A: iD, and COl B = route, either swap the columns or have a temp column for route before the id
Col A : Route
Col B : ID
And your sheet 2 look like
Col A: BLANK
Col B : Route
Use VLOOKUP in Sheet 2
AS
=VLOOKUP(B2, sheet1!A:B, 2, false)
If sheet 1 is like
COL A: iD, and COl B = route, either swap the columns or have a temp column for route before the id
