Build a program in excel to match one set of criteria with other

We are arranging loans to our customers from various banks. Each bank has got a different set of criteria. Everytime a customer inquires we have to choose from the list of criteria manually written in excel. We want this job to be done by excel itself. For this customer information form ,banker information form and the program that will match all the banks to shortlist the doers and non doers is to be designed, also the report has to be designed that will display the required end result