Forum Discussion
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
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.