SOLVED
Home

Help with lookup formula

%3CLINGO-SUB%20id%3D%22lingo-sub-719996%22%20slang%3D%22en-US%22%3EHelp%20with%20lookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719996%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI've%20fairly%20new%20to%20Excel%20so%20excuse%20me%20if%20I%20don't%20explain%20things%20correctly.%26nbsp%3B%20I%20have%20an%20Excel%20file%20in%20a%20folder%20under%20My%20Documents%20on%20my%20computer%20(Windows%2010).%26nbsp%3B%20I%20have%20another%20Excel%20file%20where%20I%20want%20a%20cell%20to%20look%20up%20the%20contents%20of%20a%20cell%20in%20that%20other%20file%20and%20display%20it.%26nbsp%3B%20I've%20been%20trying%20to%20figure%20out%20how%20to%20do%20this%20and%20I'm%20having%20trouble.%3C%2FP%3E%3CP%3ECan%20anyone%20give%20me%20a%20suggestion%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719996%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-720116%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20lookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366469%22%20target%3D%22_blank%22%3E%40Karen7459%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20to%20link%20the%20cells%2C%20open%20both%20files%2C%20in%20the%20target%20cell%20of%20one%20file%20start%20typing%20%3D%20when%20click%20on%20source%20cell%20in%20another%20file.%20After%20that%20you%20may%20close%20this%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-725016%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20lookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BWow!%26nbsp%3B%20That%20was%20so%20easy%20and%20here%20I%20am%20wracking%20my%20brain%20thinking%20it%20is%20this%20complex%20formula!%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-725067%22%20slang%3D%22en-US%22%3ERE%3A%20Help%20with%20lookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725067%22%20slang%3D%22en-US%22%3EHi%20%40Sergei%2C%20maybe%20you%20can%20assist%20me%20with%20my%20formula.%20I%20have%202%20sheets%20and%20this%20is%20my%20syntax%3Alook%20up%20data%20in%20sheet%201%20column%20A%20Sheet%202%3B%20relating%20to%20data%20in%20column%20B%20of%20sheet%201%3B%20same%20data%20in%20sheet%201%20column%20c%20with%20the%20value%20in%20column%20J%20in%20sheet%202%3C%2FLINGO-BODY%3E
Karen7459
New Contributor

Hello,

I've fairly new to Excel so excuse me if I don't explain things correctly.  I have an Excel file in a folder under My Documents on my computer (Windows 10).  I have another Excel file where I want a cell to look up the contents of a cell in that other file and display it.  I've been trying to figure out how to do this and I'm having trouble.

Can anyone give me a suggestion?

Thank you!

3 Replies
Solution

@Karen7459 

 

If you mean to link the cells, open both files, in the target cell of one file start typing = when click on source cell in another file. After that you may close this file.

@Sergei Baklan   Wow!  That was so easy and here I am wracking my brain thinking it is this complex formula! 

Thank you so much! :)

Hi @Sergei, maybe you can assist me with my formula. I have 2 sheets and this is my syntax:look up data in sheet 1 column A Sheet 2; relating to data in column B of sheet 1; same data in sheet 1 column c with the value in column J in sheet 2
Related Conversations