How can i input an exact number and have excel show me results within a tolerance?

I am glad to see that my question was understood. I wasnt really sure how to explain it. Thank you for all the help and suggestions. I really like what 6StringJazzer suggested. It definitely helps!

Please don't think i am not grateful, but ideally, I would like to be able to type in the target diameter and have the worksheet filter out all rows that are not possibilities. I am only as smart as an average excel person, but some people i work with have a hard time with computers in general. Those people will be using this spreadsheet also, so i want to make it as simple and clear as possible. I'd like to tell them, all you have to do is "type in your target diameter here" and excel shows them nothing but the mandrels that can be used.

I didn't realize i could attach my spreadsheet. Ill attach it now so all you Excel wizards can work your magic.