Hi I'm new here, unfortunately I won't be able to offer much help to others


I'm looking for a formula where a column can grab information from another sheet depending on the value of a corresponding value.

I have a list of all our sports club members and each fall into different categories - Child, Student, Adult and Senior.

I want to have a separate sheet for each category so the formula needs to look up the category and return the names from the corresponding cell.

I assume there is a straight forward formula but i cant seem to find it.

Many Thanks