Query.xls

Hi all.

Please see attached. I would like to use a List Box (Or other if you think apporpriate) which when pressed looks up information on another tab to populate boxes alongside it.

For Example: You click 'Student 1' using the List Box and it populates the boxes to the right with certain information (more clearly shown in Excel Attachment).

I would like the list box to include the full Name and also DOB.

I have tried various options (knowledge of excel is limited) - such as VLOOKUP, OFFSET, and so on.

Please Help