How to auto populate new column based on another column

2018-04-23 19:14:03

hope everyone is well;

I am trying to auto-populate a column based on another column's choice. For Example, Column A (labeled Job Title) there are 4 choices. I would like to have another column (Column B) auto populate with text based on a lookup from another list. Ive tried several ways to do this and have come up empty. My current method seems to have gotten me closer than the previous ways. I have created a column (Column B) labeled Default Job Access. That column is a calculated column and in the formula, i have =IF([Job Title] = CSP;"TRUE";"FALSE"). If i can get this to work, then ill change TRUE and FALSE to text stating the job access. If this doesnt make sense, i just frustrated.