display data form chosen record of a list

G

genjuro123

Hello there! I'm a little newbie to excel and i want to do something
with some records.
I have some lists of records in a sheet for example

cities Athens Kavala Thessaloniki

---------- ---------------- ----------------
----------------------
Athens 15 35 89
Kavala 26 85 90
Thessaloniki 89 23 34

I want a list in a new sheet that will contain all the records form
cities and when i chose a record for example Athens, to display on the
cell below all the records that "Athens" contains : 15,26,89.

I have made the lists but i dont know how to display the data from
every list when i make the selection. Does anyone know how to do this
and is this possible????
 
Top