Hello -

A friend has asked for some help and I'm not sure where to begin so
that the best solution is created ...

This person works for a Community Center, responsible for sports
activities. One of the things he keeps track of is which referees
have worked at which fields. Currrently, his tracking sheet has
referee names in column A (starting at A5) and the fields that they've
worked at in column B -- it's likely that a cell in colB will have
multiple field names in it (separated by Alt-Enter).

He wants to create a way to enter a field name (on a different sheet
within the WB) and get a list of the referees who have worked there.
What's the best way to do this? I suspect his tracking sheet needs to
be modified to allow for a search, but how?

Any help is greatly appreciated!

TIA,
Ray