Transferring Data Between Two ExcelWorksheets Closed

Question

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.

rizvisa1 · Answer

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

Transferring Data Between Two ExcelWorksheets

1 response

Similar discussions

Subscribe To Our Newsletter!