Hi

Try looking data validation and lookup functions in the Help

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Guntars" wrote:

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