Lender Matrix

We are a finance brokerage and we need a simpler way to map out some of the policies around what each of our finance lenders will or wont do. We have a number of fields when we get any application that we review against lenders policy to figure out if they will or wont do a loan. Because there is a number of fields as well as we have quite a few lenders - it is time consuming process. What I want is to get an excel sheet where we select each of the fields and from a drop down pick their relevant answer, which will then give me a list of all our lenders that will do this scenario. We would then need to go through a do for a number of different fields and as we selected the answer in each field it would change the list of lenders that would do that scenario and so at the end we would be left with just the lenders that will do it. At the moment we have fields and each has a few drop down options we would need. Then they would be compared against the info for around 30 lenders. An example of the fields would be ABN, then the dropdowns or answers for the field would be 1 day, 3 months, 6 months, 1 year, 2 years, 3 years and 5 years. So we would list in the background all the lenders that would do a 1 day ABN for instance - so that if we selected this in the ABN field, then the sheet would show only lenders that do 1 day ABN. So for this it would filter a lot of lenders out vs 5 years would show most of our lenders still. The sheet would then need to be able to take this into account for the next field once that is entered i.e. GST Reg with options being as per spreadsheet attached. So as you went through each of the fields it would filter out any lenders based off the info around what they each would do. At the end of completing all 8 fields you would have a list of all the lenders that would do that deal based on the fields entered which could be all of our lenders listed or none. I have attached spreadsheet with Sheet 2 showing each field in Bold, then next to this the dropdowns or options we would want. On sheet 1 is a list of all the lenders we have. I have not gone through and listed each lender against each field and answer as was unsure of format and possibility of doing this but understand we would need to do this to make it work i.e. field ABN, option 1 day, I would then list in the background all the lenders in our list that do this. At this stage just want to get the advice and best way to dot his and someone to set it up for us so we can go through and populate the info so spreadsheet works.