Need a formula to extract names from a master list

Hi, I'm new to this forum.

My experties are rather novus and I am hear to learn from others exampels, and some day may be able to help others like me.

Thanks.

Vlady, thanks for taking time to address my problem. Following your advice I am attaching the workbook with some test data to resolve the issue. Please let me know how I can use one of these functions: IF, VLOOKUP, AND, INDEX or MATCH, etc to develop a nested formula that will automatically pick out names that meet the criteria of: "Age Group", "Active" and "Inactive". The estimated length of liest is about 250 records.
Thank you for your help.
Anies

I really appreciate your help. The formula is working for Group A for first entry but not for the second entry. One of the criteria that it also need to meet is the column 'E' in sheet S_Data for Active and Inactive. It should only picking out the data that meet the group A and Active criteria. I think a small tweeking may solve this issue. If you can sort this out for me too please. Thanks.

Maybe......

=IFERROR(INDEX(S_Data!$A$6:$A$20,SMALL(IF((S_Data!$C$6:$C$20=$C$2)*(S_Data!$E$6:$E$20="Yes"),ROW(S_Data!$C$6:$C$20)-ROW($C$6)+1),ROWS(B$5:B5))),"")

azumi, glad you could step in to address my problem. The change you suggested do work. However, I need similar solution for the "Last" name in "Group A". Can you please take a look at that too? Thanks.

For Last Names you can use formula from VLADY, that ok

Azumi and Vlady, I thank you both for helping out. Since I am not so good with the Excel tricks I would stil ask either one of you to advise me regarding best way, I should copy paste the formula for the other groups in the workbook without running into any further issues. Thanks a lot.