Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3214415%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3214415%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20use%20a%20similar%20formula%20as%26nbsp%3B%3DIF(OR(D2%3D%22ABC%22%2CD2%3D%22DEF%22)%2C%22YES%22%2C%22NO%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20need%20to%20pull%20from%20a%20different%20worksheet%20and%20have%20the%20formula%20match%20the%20name%20in%20one%20worksheet%20to%20the%20other%20worksheet.%20The%20names%20are%20not%20in%20the%20same%20order%20in%20both%20worksheets.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20need%20column%20J%20to%20populate%20%22YES%22%20if%20the%20data%20in%20a%20column%20on%20another%20worksheet%20has%20the%20text%20SC%20and%20%22NO%22%20if%20it%20does%20not%20and%20it%20needs%20to%20populate%20the%20data%20based%20on%20the%20corresponding%20name%20(not%20in%20the%20same%20order%20on%20both%20sheets).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3214415%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-3214461%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3214461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317994%22%20target%3D%22_blank%22%3E%40sstevens86%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EPlease%2C%20always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3214515%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3214515%22%20slang%3D%22en-US%22%3EUnfortunately%20all%20the%20information%20is%20classified%2C%20but%20I%E2%80%99m%20happy%20to%20give%20more%20detail%20if%20needed%20without%20the%20specifics%20in%20each%20cell.%3C%2FLINGO-BODY%3E
New Contributor

I need to use a similar formula as =IF(OR(D2="ABC",D2="DEF"),"YES","NO")

 

However, I need to pull from a different worksheet and have the formula match the name in one worksheet to the other worksheet. The names are not in the same order in both worksheets. 

 

So I need column J to populate "YES" if the data in a column on another worksheet has the text SC and "NO" if it does not and it needs to populate the data based on the corresponding name (not in the same order on both sheets). 

4 Replies

@sstevens86 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Please, always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

Unfortunately all the information is classified, but I’m happy to give more detail if needed without the specifics in each cell.

@sstevens86 

Under the name you mean some text in the cell or named range/cell ? 

Text. There’s a column of names, actual names. Ex: John Doe

I need the formula on one sheet to pull the information from another sheet for the same individual.