Excel 2007 : Link combo box content

Hi,
I have a combo box with drop down which has a capacity to hold 200 names. Is there a way to use the combo box's reference cell so when a name is selected, it can be linked to that persons' age and placed in another cell?
Much appreciate any suggesstion

I don't think there is. You will have to have your linked cell return that number, and then use an index function or similar function to return the person's age (assuming you have that value in a list/table somewhere).