Formula selection and execution

%3CLINGO-SUB%20id%3D%22lingo-sub-1592790%22%20slang%3D%22en-US%22%3EFormula%20selection%20and%20execution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592790%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20please%20get%20some%20help%20with%20a%20formula.%20see%20attached%20workbooks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20insert%20into%20Book%201%2C%20column%20E%20(%20IPS%20ID%20%23)%20by%20matching%20column%20C%20(%20previous%20asset%20id)%20to%20the%20list%20in%20Book%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1592790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1592955%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20selection%20and%20execution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F479853%22%20target%3D%22_blank%22%3E%40Eddy162%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOpen%20both%20workbooks.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20E2%20on%20Sheet1%20in%20Book1%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(C2%2C%5BBook2.xlsx%5DSheet2!%24A%242%3A%24B%246%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdjust%20the%20range%20and%20names%20if%20needed%2C%20then%20fill%20down.%3C%2FP%3E%0A%3CP%3ENow%20close%20Book2.%3C%2FP%3E%0A%3CP%3EExcel%20will%20add%20the%20path%20of%20Book2%20to%20the%20formulas%20in%20Book1.%3C%2FP%3E%0A%3CP%3ESave%20Book1.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.