Hello, I am sure this is simple to do but I am struggling. I wish to calculate some prices and as part of this I wish to pick a material size, code and price from a large table. Table looks like below on seperate sheet.
OD ID Length Code Price
50 40 50 1234 10.00
60 50 50 1235 12.00 etc etc.
On seperate sheet I enter OD, ID and Length and wish to pick ideal blank and return code and price.
Please help !!!!
Here is more data to try and make it clearer. If a part has an OD of 36 and ID of 22 and length 44 I would manually pick number 10081606
Hope this is clearer.
dimensions in mm Material Prices in
OD ID Length number EURO/Piece
14 0 30 10025602 0.49
19 0 30 10025609 0.55
23.5 0 40 10025619 0.81
24.5 13.5 16 10188209 0.32
28.5 0 50 10025636 0.93
28.5 9 20 10025642 0.40
28.5 9 62 10081590 1.22
38 0 70 10025655 2.12
38 9 62 10170642 2.46
38 17 40 10025678 1.16
38 17 62 10081606 1.83
47.5 0 160 10025696 10.51
47.5 9 62 10025707 2.50
47.5 21.5 40 10025715 2.08
47.5 21.5 50 10025716 2.02
47.5 21.5 62 10081609 2.40
57 0 100 10025729 6.05
57 17 62 10182298 3.94
57 29.5 20 10025746 1.34
57 29.5 50 10025750 2.97
57 29.5 62 10081613 3.69
66.5 0 160 10025765 20.62
66.5 24.5 50 10025772 4.03
66.5 24.5 62 10081616 4.92
66.5 39 50 10025780 3.61
66.5 39 62 10081619 4.48
76 0 110 10025792 11.51
76 34.5 62 10025803 5.52
76 34.5 90 10206559 7.66
76 49 80 10156783 6.74
90 0 160 10025828 26.81
90 30 72 10025830 9.77
90 44 62 10025838 7.56
90 44 80 10156784 10.05
Bookmarks