Search based on multiple conditions.

[ezzat hesham]

hello there,
i would like to know if excel could apply search based on multiple condition and return a specific value that match with all conditions and there is the assumption.

if i work in a bank and the bank sometimes do investigations to some customers to check their valid to have a credit card and the bank doesn't investigate by itself its contract with outsource companies to do this, and each company cover different area and region, also each company have a distribution rate

what would i do is to make excel distribute the investigations on the companies based on 2 conditions the area and the distribution rate, its some complicated idea
in another way

there is a table in sheet 1 have the investigations and customers, and there is a column in this table to identify which company will go with this investigation

in another sheet (sheet 2) there is another table it have the distribution rate for each company
and sheet 3 have the table of areas and regions and each company covers

i want to automate the distribution of companies in sheet1 based on area or region of investigation and the company rate to return which company will take this investigation

Regards,