Sort based on multiple variable conditions

I'm creating a spreadsheet that will take about 500 different medical plans and sort them based on how close they are to a clients current plan. I'm looking at about 6 columns with information in them that I would sort on. Two examples of the data colums would be deductible and doctor visit copay.

Example: companies current plan has a $1,500 deductible and a $20 doc visit copay. I put those two values in and the 500 plans are sorted based on the deductible and then the doc copay. Here's the kicker I need help with. The company may say we want the deductible to be $1,500 or less or they might say it can be a little more. But in the end I need to sort the plans that are the closest match (above and below) to their variables.

Can you elaborate on what you mean by a helper column? I do have control over the colums since this is being developed from the ground up.

Yes I can add a column for that. If the plan had a $1,500 deductible then $1,750 and $1,250 would be closer matches than $1,000 and $3,000. How would you structure the formula so the $1,750 and $1,250 show first? Would you use a percentage variable or something else?

Thanks, let me give it a run and see how it works out.

I decided to add helper columns that figured the percentage match to base numbers. This gives me positive and negative percentages so now I want to sort the percentages so the ones closest to zero are at the top of the list any ideas?