SOLVED

Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2272078%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272078%22%20slang%3D%22en-US%22%3EHi%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20certain%20this%20is%20the%20right%20location%20for%20this%20but%20here%20goes!%3CBR%20%2F%3EI%20have%20a%20spreadsheet%20which%20is%20really%20a%20large%20table.%20I'm%20trying%20to%20get%20info%20from%20this%20main%20table%20into%20a%20separate%20worksheet.%20What%20I%20need%20is%20a%20formula%20that%20says%20something%20like%20%22If%20any%20cell%20in%20sheet1%20contains%20the%20same%20name%20as%20cell%20a1%20in%20sheet%202%2C%20then%20in%20a2%20show%20the%20text%203%20rows%20down%20from%20the%20found%20text%20in%20sheet1%22%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2272078%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-2272330%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272330%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1025738%22%20target%3D%22_blank%22%3E%40Danielwood1985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20that%26amp%3Bapos%3Bs%20what%20you%26amp%3Bapos%3Bre%20looking%20for.%20Without%20a%20file%20(without%20sensitive%20data)%20it%20is%20difficult%20to%20guess%20what%20the%20user%20wants.%3CBR%20%2F%3EIf%20nothing%20is%20what%20you%20are%20looking%20for%2C%20please%20include%20a%20file%20and%20a%20detailed%20explanation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(A1%3DSheet2!A1%2CSheet1!A3%2CSheet1!A1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20inserted%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi All,

I'm not certain this is the right location for this but here goes!
I have a spreadsheet which is really a large table. I'm trying to get info from this main table into a separate worksheet. What I need is a formula that says something like "If any cell in sheet1 contains the same name as cell a1 in sheet 2, then in a2 show the text 3 rows down from the found text in sheet1"
3 Replies
best response confirmed by Danielwood1985 (New Contributor)
Solution

@Danielwood1985 

Not sure if that's what you're looking for. Without a file (without sensitive data) it is difficult to guess what the user wants.
If nothing is what you are looking for, please include a file and a detailed explanation.

 

=IF(A1=Sheet2!A1,Sheet1!A3,Sheet1!A1)

 

Please see the inserted file

 

I would be happy to know if I could help.

 

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

 

Thank you for this. It does work.

Annoyingly though, I haven't explained myself very well.

Sheet 1, across row 4, from d4, has different titles.
Sheet 2, column c downwards, has those titles.

For every x in Sheet2 cell C*, where C* is present in Sheet 1, row4, in sheet2 d* show what's 3 rows down in sheet1.

I'm thinking it may be too complex for a formula and a macro may be needed?

@Danielwood1985 

INDEX/MATCH shall work if in C are unique values. Better to have sample file to illustrate on concrete formula. It also depends on which version of Excel you are, in general on 365 or not.