Previous Topic Next Topic

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

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