Formula selection and execution

Occasional Contributor



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

1 Reply


Open both workbooks.

Enter the following formula in E2 on Sheet1 in Book1:




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.