I have 2 files with unique ID & name; need name from 1st file into 2nd but they're not in same order

Assuming you have two files; Book1 and Book2 with ID & Name columns as Column A and Column B Enter the following formula to the cell of Book2 that you want to call the value to. In this case, it is Cell B1; =VLOOKUP(A1;[Book1]Sheet1!$A$1:$B$2;2;0) A1 is the value of ID on Book2 and $A$1:$B$2 is the array of the data.

Forum Discussion

Anonymous

Sep 05, 2017

Populating data from 2nd file when unique IDs are not in the same order

I have 2 files with unique ID & name; need name from 1st file into 2nd but they're not in same order

BI & Data Analytics

Need Help

1 Reply

Koray Bala
Copper Contributor
Sep 05, 2017
Assuming you have two files; Book1 and Book2 with ID & Name columns as Column A and Column B Enter the following formula to the cell of Book2 that you want to call the value to. In this case, it is Cell B1; =VLOOKUP(A1;[Book1]Sheet1!$A$1:$B$2;2;0) A1 is the value of ID on Book2 and $A$1:$B$2 is the array of the data.