Search a table and return rows based on criteria of 2 cells

[slugwisper]

Hello!

I'm looking to search a table like the the one below. In a separate sheet in the workbook, I'd like to have the "Subject" as multiple columns and list underneath it all of the titles that match the subject and have the language in english. I tried working a combination of index and match but i was getting entire rows of data instead of just the title. I would greatly appreciate any help!

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

Title	Language	Subject
Idioms	english	language-arts
Refranes	spanish	language-arts
Name That Character Trait	english	language-arts
Nombra el rasgo del personaje	spanish	language-arts
Telling Stories	english	language-arts
Contar una historia	spanish	language-arts
Todo sobre la Energía	spanish	physical-science-and-engineering
All About Energy	english	physical-science-and-engineering
Build an Epic Sandcastle!	english	physical-science-and-engineering
Construye un castillo de arena épico	spanish	physical-science-and-engineering
Just Press Print!	english	physical-science-and-engineering
Solo presiona imprimir	spanish	physical-science-and-engineering
Making Better Bubbles	english	physical-science-and-engineering
Címo hacer mejores burbujas	spanish	physical-science-and-engineering
Making Crayons	english	physical-science-and-engineering

<colgroup><col style="width: 100px"><col width="100"><col width="182"></colgroup><tbody>
</tbody>

Want to return:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

physical-science-and-engineering	language-arts
All About Energy	Idioms
Build an Epic Sandcastle!	Name That Character Trait
Just Press Print!	Telling Stories

<colgroup><col style="width: 186px"><col width="145"></colgroup><tbody>
</tbody>

 

[Fluff]

How about
In B1 copied right
=IFERROR(INDEX(Sheet1!$C$2:$C$16,MATCH(0,INDEX(COUNTIF($A$1:A$1,Sheet1!$C$2:$C$16),0),0)),"")
and in B2 copied down & across
=IFERROR(INDEX(Sheet1!$A$2:$A$16,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$16)-ROW(Sheet1!$A$2)+1)/((Sheet1!$B$2:$B$16="english")*(Sheet1!$C$2:$C$16=B$1)),ROWS($A$1:$A1))),"")