Formula selection and execution

[Eddy162]

Hello 

Can I please get some help with a formula. see attached workbooks. 

I need to insert into Book 1, column E ( IPS ID #) by matching column C ( previous asset id) to the list in Book 2.

Thank you

[#2]

@Eddy162 

Open both workbooks.

Enter the following formula in E2 on Sheet1 in Book1:

=IFERROR(VLOOKUP(C2,[Book2.xlsx]Sheet2!$A$2:$B$6,2,FALSE),"")

Adjust the range and names if needed, then fill down.

Now close Book2.

Excel will add the path of Book2 to the formulas in Book1.

Save Book1.