How : Interactive Search for multiple rows and columns

Hi,

I need help to make a search option, which will give me back the search results from another sheet with multiple search values

Example : I input Two teams thorugh a VBA code(already done). These two teams has the value A1 = Home/Visitor, A3 = TeamName and A5="W" so on......

Capture.JPG

So I tap submit and the it gets transfer in the database of another sheet

Here :

Capture.JPG

My Query :

Can i build a search option. Where I input 3 most important value which is "G""R""W""B""Y" (Short for green, red colour etc..)

And the search result will give me back the results based on 100% match, 90% match ,80% matc so on. For both Home and Visitor through the database.

Example : In the databse
A3=G,B3=G,C3=R

And search input is "G","G","G"

The search results should also pull up "G""G""R" cause two of the conditons met . First two values are "G""G"
If the condition is true for "Home Team". It should also pull up for the value for visitor. As both teams played matches that day

There are instructions at the top of the page on how to post a sample sheet.Thanks