I'm trying to create a formula where a name in a corresponding cell would be recognized and another name generated based on that name (e.g. put a student's name in a cell and a teacher's name for a department that has the student automatically puts the teacher's name in that box)
Solved by G. C. in 12 mins