Hi all,

I am wondering what the best method would be to create a lookup. I have
this column of data (Column A) with Sub-Committees and different people
that belong to these Sub-Comms. The Name range is defined as
"Sub-Committees"

I want to be able to type in a name and the result should be:

1. Person does exist; and
2. They belong to x,y,z Sub-Committee(s) - plural if they are in more
than one Sub-Committee.

or

1. Person not in current list;
2. Choose which Sub-Committee(s) they need to be added; and
2. Add their name.

Any and all help is very much appreciated.

Shiraz.