Having problems with finding correct formula for situation
Hello, I am needing to make a list of all the values in one column if the name is found in another column. This is a completely different scenario but this situation might make more sense than the data I am analyzing.
For example, imagine in column 1 you have a list of all the students enrolled in a school. In Column 2, you have that child's teacher's name. Basically, I am trying to find the correct formula to say if column 2 has a value of Mrs. Smith, then return the child's name from column 1.
Basically, I want to create a summary for a dashboard that is like turning on a filter to show a list of all the children in that classroom.
Help Article Resources
Check out the Formula Handbook template!