Excel formula required

Hi, I want to return a value in a cell if I select a value from a drop down menu in another cell. Can anyone help me with an example of such a formula? I’m working on MS Excel 2007. Robert