You don't need a listbox, or even any code at all. Instead, use Data
Validation and Vlookup. Here's a sample workbook:
http://www.myexpertsonline.com/freedls/pricelist.xls

Here's info on Data Validation:
http://www.officearticles.com/excel/...soft_excel.htm

Here's info on Vlookup:
http://www.officearticles.com/excel/...soft_excel.htm

Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"pgc" wrote in message
oups.com...
hi i have a data base looking something like this
Name Training topics training needed training completed
Paul Hilti Gun Yes NO
Paul Paslode Yes Yes
Steve Hilti Gun Yes NO
Steve Paslode Yes NO
on a seperate worksheet i have this
List box containing all names Training topics Training completed
Steve


I want the "training topics" column and "training completed" column to
show the rows in the data base based on which name i pick from the list
box please help
Ive tried Index / Match but i only get the first row ie Hilti and there
are more than two items in the "Training needs" column
IM realy struggling
Thanks