Multi Condition Flag

Hello -

My problem is the following:

I have a list of bonds for three different companies.

I need to write a formula which identifies my "benchmark" 10year bond for each company.

For a bond to be considered my benchmark, it needs to meet the following conditions:
1) Crncy = USD
2) Amt Outstanding (USD) > 100,000,000
3) maturity of the bond is closest to 10 years as compared to all other USD denominated bonds of the same company with more than 100,000,000 Amt Outstanding (USD)

This needs to be accomplished with VBA or a formula (rather than a pivot) and the result of the formula needs to drop a flag into column D which can then be used for other lookups.

Thank you very much!