I hope that the picture will be displayed or you could click on the link and
open it up.
http://www.eonstone.com/F250/list_1.jpg
This is my challenge: I got this spreadsheet where I keep track of employees
who are been on the events.
I want to create a separate €œlookup€� spreadsheet where I will have a drop
down list of event names (1).
Once I select the event from dropdown list, I would like to display a list
of attendees (3) who been on that event (2), marked by €œX€�
I think this is calling for multicell array formula.

Thank you for the help,
And I hope that you will be able to open my challenge illustration
Guntars