Find all data using one criteria

I have attached a sample file to help with my problem

I have two worksheets one called output and one called data.

I would like to populate columns B and C in the output worksheet using data from the data worksheet.

The user should choose an option from the dropdown menu in cell B2 on the output worksheet sheet.

I would like to show all the training done in column B and the date the training was done in column C.

A sample answer would be

If "A" was selected from cell B2

[TABLE="class: grid, width: 300, align: left"]

[tr]

[td]

Training

[/td]

[td]

Date

[/td]

[/tr]

[tr]

[td]

SI

[/td]

[td]

June-12

[/td]

[/tr]

[tr]

[td]

VST

[/td]

[td]

Jan-13

[/td]

[/tr]

[tr]

[td]

PWW

[/td]

[td]

Sept-13

[/td]

[/tr]

[tr]

[td]

TS

[/td]

[td]

Nov-13

[/td]

[/tr]

[/TABLE]

I hope someone can help.

forum.ozgrid.com/index.php?attachment/69337/