ok i am trying to get a combo box to list a list of names and then in a few text boxes or cells next to the combo box display information relevent to what was chosen in the combobox.

for example:

the combo box lists :

Nick
Ant
Sally

I want to be able to choose e.g. nick and then in a text box or cells next to nick see information that is stored in a different table (e.g.) tall, 22, M

I know you can do this in Access but not sure how to in Excel.