Dynamic Search function using array formulas

Hi all,

I'm trying to create a dynamic search function that will search a database in one tab and return a list of entries matching the criteria searched for in another tab. Currently I can do this for two search criteria but I want to extend it to many more (14 in total) search parameters. You should be able to search by any combination of parameters.

Please see the attached file for where I've got to.

I'm using the following formulae as a basis:

First parameter
=IFERROR((INDEX(FundSearch, SMALL(IF(ISNUMBER((SEARCH($L$3, InvestorSearch))*(SEARCH($B$3, FundSearch))), ROW(FundSearch)-MIN(ROW(FundSearch))+1, ""), ROW(Database!A1)))),"")

Second parameter
=IFERROR((INDEX(InvestorSearch, SMALL(IF(ISNUMBER((SEARCH($L$3, InvestorSearch))*(SEARCH($B$3, FundSearch))), ROW(FundSearch)-MIN(ROW(FundSearch))+1, ""), ROW(Database!A1)))),"")

Can someone please help?

Thanks MarvinP, I never realised the power of Advanced Filter! Works great for this task so a very big THANK YOU!