SOLVED

IF statement that references a table

%3CLINGO-SUB%20id%3D%22lingo-sub-1434878%22%20slang%3D%22en-US%22%3EIF%20statement%20that%20references%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434878%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20trouble%20getting%20a%20lengthy%20IF%20statement%20to%20work%2C%20and%20I%20believe%20it%20needs%20to%20come%20from%20a%20table%20(or%20be%20one%20really%20long%20formula).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20reports%20that%20do%20not%20include%20team%20alignment%20with%20team%20leaders%20and%20the%20appropriate%20support%20person.%20Tom%20works%20with%20Nancy%2C%20Liz%20works%20with%20Jim%2C%20etc.%20I%20have%20a%20full%20column%20of%20team%20leaders%2C%20but%20the%20report%20never%20has%20our%20updated%20alignment%20of%20support%20persons.%20Can%20I%20have%20a%20cell%20simply%20look%20to%20another%20cell%2C%20see%20who%20the%20team%20leader%20is%2C%20and%20then%20fill%20in%20the%20appropriate%20support%20person%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3E%3CP%3ETom%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3ENeed%20this%20to%20auto-populate%20Nancy%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3ELiz%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3ENeed%20this%20to%20auto-populate%20Jim%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1434878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434898%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%20that%20references%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687147%22%20target%3D%22_blank%22%3E%40CoreyCarson%3C%2FA%3E%26nbsp%3BAre%20your%20team%20leaders%20and%20support%20persons%20are%20related%20to%20each%20other%20based%20on%20some%20common%20criteria%20such%20as%20same%20Department%2FDivision%2C%20same%20Project%2C%20etc.%3F%20If%20they%20are%20not%20and%20randomly%20assigned%20to%20each%20other%20instead%2C%20you%20will%20have%20to%20create%20different%20sets%20of%20team%20leader-members%20then%20use%20formulas%20to%20look%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435600%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%20that%20references%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435600%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687147%22%20target%3D%22_blank%22%3E%40CoreyCarson%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ECheck%20if%20the%20attached%20file%20solves%20your%20query%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438729%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%20that%20references%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686497%22%20target%3D%22_blank%22%3E%40saybhatt%3C%2FA%3E%26nbsp%3BThat%20was%20exactly%20what%20I%20needed.%20Thank%20you%20very%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm having trouble getting a lengthy IF statement to work, and I believe it needs to come from a table (or be one really long formula). 

 

I have reports that do not include team alignment with team leaders and the appropriate support person. Tom works with Nancy, Liz works with Jim, etc. I have a full column of team leaders, but the report never has our updated alignment of support persons. Can I have a cell simply look to another cell, see who the team leader is, and then fill in the appropriate support person? 

 

Tom

Need this to auto-populate Nancy
LizNeed this to auto-populate Jim

 

 

3 Replies
Highlighted

@CoreyCarson Are your team leaders and support persons are related to each other based on some common criteria such as same Department/Division, same Project, etc.? If they are not and randomly assigned to each other instead, you will have to create different sets of team leader-members then use formulas to look up.

Highlighted
Best Response confirmed by CoreyCarson (New Contributor)
Solution

Hi @CoreyCarson,

Check if the attached file solves your query

Highlighted

@saybhatt That was exactly what I needed. Thank you very much!