I am attempting to have one column fill with one of 5 responses based on what is typed in another column. In this case, my C column can have 1 of 5 values placed into it (Staff, Faculty, Student, Visitor, and Vendor), from there I want my J Column to have another word placed into it. I am not quite getting this to work for me. Any advice on how to get this to work?