Transferring Data Between Two ExcelWorksheets

Closed
Truetide - Mar 4, 2010 at 12:12 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 4, 2010 at 12:19 PM
I have a master worksheet (Worksheet1) that has two columns titled ID and Route. Each Route has a corresponding ID assigned to it. There are about 1600 rows (records) in this worksheet. I have another worksheet (Worksheet2) that also has an ID column (which is empty) and a Route column (which is populated). I need to fill in the ID numbers in Worksheet2 that correspond to the matching Routes in Worksheet1 without having to do it manually. Can anyone give me some guidance on this. Thanks in advance for any help.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0