Formula selection and execution

Occasional Contributor

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

1 Reply

@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.