Select Specific Cell Based on Value

[cha]

Hi,
I have a list of classes. I want to make a new sheet and categorize them by class family.
I used vlookup on the class to get its family, so I figured out how to get that family key mapped to each class. I have a Family sheet made already.
Based on the vlookup value (family), how do I copy the class data onto the Family sheet and paste it as a new row into its proper section?


Suggestions please?

Here is the first table. (The family for B => f2, D=>f4, E=>f5)

<table class="cms_table" width="193"><tbody><tr class="cms_table_tr" valign="top"><td class="cms_table_td">Start Date</td> <td class="cms_table_td">Class</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">8/9/2011</td> <td class="cms_table_td">B</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">8/10/2011</td> <td class="cms_table_td">D</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">8/10/2011</td> <td class="cms_table_td">E</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">8/11/2011</td> <td class="cms_table_td">E</td> </tr> </tbody></table>

This is the final table I'm trying to fill in:

<table class="cms_table" width="256"><tbody><tr class="cms_table_tr" valign="top"><td class="cms_table_xl65" width="64">Family</td> <td class="cms_table_td" width="64">Start Date</td> <td class="cms_table_td" width="64">Class</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">f1</td> <td class="cms_table_td">
</td> <td class="cms_table_td">
</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">f2</td> <td class="cms_table_td">
</td> <td class="cms_table_td">
</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">f3</td> <td class="cms_table_td">
</td> <td class="cms_table_td">
</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">f4</td> <td class="cms_table_td">
</td> <td class="cms_table_td">
</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td">f5</td> </tr></tbody></table>