I've attached an example. In the top I would like to be able the dimensions I have for the part. There will be at least ten of these tables that I would like to be able to search through using this method, it would be very easy to put them all on one sheet as well. I just need a way for it to find which standard and what Nominal Size that the washer would fall into. I'm not sure if there's a way to display the text of the size and table name at the top or even highlighting the row that it's in would be sufficient.
Thanks for any help!
Here's the table incase the attachment doesn't work:
ID OD Thickness
Enter Value Enter Value Enter Value
Commercial Flat Washers - 316 Stainless
OD ID Thickness
Size Max Min Max Min Max Min
1/4 0.63 0.62 0.286 0.276 0.055 0.045
1/4 0.693 0.683 0.286 0.276 0.055 0.045
5/16 0.755 0.745 0.348 0.338 0.055 0.045
3/8 0.88 0.87 0.411 0.401 0.055 0.045
3/8 1.005 0.995 0.411 0.401 0.055 0.045
1/2 1.255 1.245 0.567 0.557 0.067 0.057
Bookmarks