How to the text/word of a cell in excel 2010

Hi,

I am working on creating an excel spreadsheet in which I want a series of names to be outputted if the condition of another cell is valid.

For example:-

If the user selects "August" from a drop down menu then the cell should output the name of a person mentioned in another sheet in one of the cells.

Though I want a names in each individual cell but for now if anyone could help me with the use of the basic formula needed for my problem.


Thanks.


Rgds,
Mandy