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

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

Hi pgc,

You could write some complicated VLOOKUPS or a bit of VBA, but
this sounds like a good job for a Pivot Table.

Change the NO values to 0 and Yes yo 1
Format the data using the custom number format
"Yes";"Yes";"No"

Select the table, including headings.
If you want the selection to grow with the data list,
select the whole columns or use a dynamic range.

Use the menu item Data - Pivot Table... to create
a Pivot Table with;
Name as a Page field
Training Topics as a row field
Training Needed as a data field
Training Completed as a data field

Format both data fields with the custom number format
"Yes";"Yes";"No"

Use the EFutil add-in at http://edferrero.m6.net/vba.shtml
to change the alignment of the data fields
(makes the table look better)

Go to http://edferrero.m6.net/tutorials.shtml if
you want to know more (with pictures!)

Ed Ferrero
http://edferrero.m6.net


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

Solution suggested does not return multiple rows as requested by the OP.

--
Regards,
Tom Ogilvy


"Anne Troy" wrote in message
news:70281$42bbb8c7$97c5108d$3222@allthenewsgroups .com...
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