IF statement that references a table

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 tea...